Calculated Expression in Pivot Table

[#1]

Hi:

I have a pivot table with Sales $ in the expression and Market, Year & Month as dimensions. But I would like to add a calculated expression just one time at the very end of the table and do not want it to appear against each month.

Would this be possible.

thanks

Kumar

[its_anandrjs]

Hi,

Can you explain more with a sort of small example.

Thanks & Regards

[chiru_thota]

you can do it with Pick function instead of individual expression I guess.

Ex

Pick(MetricSequence,if(condition,sum(sales)),sum(Profit),Sum(staff)) etc

[srchilukoori]

do you have a screenshot or an excel sample ?