How to add Average and MoM Trend as my last 2 columns in Pivot table

[sushreesamantsinhar]

Hello,

I have already designed below pivot table using Data load editor . Need help to add last 2 column 'Average' & 'MOM Trend' 

Category	KI	Report	Amber	Red	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Average	MOM Trend
a	x	R1	d	e	1	2	3	4	5	7	8	9	4.8	up
b	y	R1	d	e	4	-	6	7	8	6	7	6	6.5	down
c	z	R2	d	e	4	5	6	7	-	6	7	7	6.3	-

 Dimension -Row - 'Category', 'KI', 'Report', 'Amber' and 'Green' 

 Dimension -Column - Reporting Date (MMM-YY)

Measure -  Sum(Amount) or Count(Amount) based up on 'KI' field value.

Question - I want to add 'Average' & 'MOM Trend' as the last 2 columns in the pivot table.

 Average - Average amount should change based on the selected Reporting Date(MMM-YY)

MOM Trend - Should be 'Up'  if  Sum(Amount) of Feb 23  > Sum (Amount) of Jan 23 - 

please advise.

Regards,

Sushree