@Michael_Tarallo, @sunny_talwar @marcus_sommer
Hello,
I need your help to add 'Average' & 'MoM Trend' as the last 2 columns in the pivot table .
| Category |
KI |
Report |
Mar-23 |
Apr-23 |
May-23 |
Jun-23 |
Jul-23 |
Aug-23 |
Average |
MoM Trend |
| cat1 |
KI1 |
R1 |
3 |
4 |
5 |
6 |
7 |
8 |
5.5 |
up |
| cat1 |
KI2 |
R1 |
8 |
- |
8 |
9 |
10 |
9 |
8.8 |
down |
| cat1 |
KI3 |
R2 |
4 |
5 |
6 |
7 |
- |
9 |
6.7 |
up |
(Dimension - Row) - Category , KI , Report
(Dimension - Column) - Reporting Date (MMM-YY)
Measure - sum( amount) or row(amount) based on KI value.
I used Data load editor to get these data and converted into pivot table, now I want to add last 2 columns 'Average' and 'MoM Trend' . Based on the Reporting month selection - the 'Average' & 'MoM Trend' should change.
Please advise.
Thanks in advance,
Sushree
