topic Re: Row Based custom column in Pivot table in App Development

Row Based custom column in Pivot table

Aditya_Chitale — Sat, 23 Apr 2022 20:24:54 GMT

Hi everyone,

I want to add a custom column at the end of pivot table like shown below (the one in yellow)

	Apr-22	May-22	YTD sum total	NRR
Target	360	50	410	205
SO created	152	0	152	76
CRM approved	66	0	66	33

I have added Month Year as my Dimension(column) and Target, SO created and CRM Approved as my measure values and calculated YTD Sum total using Total functionality

Current output:

Need help in adding NRR column. Formula for the same is:

NRR = YTD Sum Total / total count of months (Here 2)

So, NRR for Target will be 410/2 = 205

Regards,

Aditya

Re: Row Based custom column in Pivot table

andrzejdobiegal — Sun, 24 Apr 2022 20:16:59 GMT

You can add calculated dimension =aggr( sum(Value)/count(MonthYear), Type)

regards Andrzej

Re: Row Based custom column in Pivot table

Aditya_Chitale — Mon, 25 Apr 2022 03:14:30 GMT

@andrzejdobiegal

Is there any way to rename it like measure columns ?

Regards,

Aditya

Re: Row Based custom column in Pivot table

andrzejdobiegal — Mon, 25 Apr 2022 05:18:33 GMT

Yes, chart properties, Label.

regards Andrzej