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.
