Hi,
I was using pivots for period on period analysis and then provide comments using some basic formulae.
Is it possible to do same using Alteryx, with minimal no manual intervention.
Period 1 Data
| Date | Name | Product | Sales in kg | Profit in GBP | Country | IS LLC |
| 31-Mar-19 | ABC | Steel | 500 | 115 | IN | N |
| 31-Mar-19 | ABC | Iron | 200 | 220 | US | N |
| 31-Mar-19 | CAB | Steel | 600 | 204 | UK | Y |
| 31-Mar-19 | CAB | PoP | 100 | 50 | UK | Y |
Period 2 data
| Date | Name | Product | Sales in kg | Profit in GBP | Country | IS LLC |
| 31-Mar-20 | ABC | Steel | 400 | 220 | IN | N |
| 31-Mar-20 | ABC | Iron | 300 | 207 | US | N |
| 31-Mar-20 | CAB | Steel | 500 | 45 | UK | Y |
| 31-Mar-20 | CAB | PoP | 350 | 190 | UK | Y |
| 31-Mar-20 | dcb | gold | 200 | 210 | AU | Y |
by combining both tables I used to prepare Pivot and the comments using & functions.
| Is LLC | Name | Country | Product | 2019 - Sales | 2020 - Sales | 2019- Profit | 2020 - Profit | Sales Diff | Profit Diff | Comment Sales | Comment profit |
| N | ABC | IN | Steel | 500 | 400 | 115 | 220 | -100 | 105 | Movement in Sales for ABC operating in IN is -100 GBP | Movement in Sales for ABC operating in IN is 105 GBP |
| N | ABC | US | Iron | 200 | 300 | 220 | 207 | 100 | -13 | Movement in Sales for ABC operating in US is 100 GBP | Movement in Sales for ABC operating in US is -13 GBP |
| Y | CAB | UK | PoP | 100 | 350 | 50 | 190 | 250 | 140 | Movement in Sales for CAB operating in UK is 250 GBP | Movement in Sales for CAB operating in UK is 140 GBP |
| Y | CAB | UK | Steel | 600 | 500 | 204 | 45 | -100 | -159 | Movement in Sales for CAB operating in UK is -100 GBP | Movement in Sales for CAB operating in UK is -159 GBP |
| Y | DCB | AU | Gold | | 200 | | 210 | 200 | 210 | Movement in Sales for dcb operating in AU is 200 GBP | Movement in Sales for dcb operating in AU is 210 GBP |
| Grand Total | | | | 1400 | 1750 | 589 | 872 | | | | |
Can some one help me in creating same using Alteryx?
