Totals on Pivot table for expressions in rows

[#1]

Hello All,

I am looking for help to solve this problem. Any help would be very much appreciated. Thanks in advance.

[#2]

Hello,

I didn't understand well your question, but is this what are you looking for?

IF([(expressions)]='Budget TY',Avg(sold),Sum (sold))

[Siva_Sankar · Accepted solution]

Pankaj,

You can use dimensionality function in expression of pivot table to achieve this. check the attached application.

[Anonymous]

in Total Mode use 'Average'

[razvan_brais]

Hey guys , I have a question. How did you put your total of each column at the end at the table. I cannot find how you did that.

Thank you