Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Can you explain more with a sort of small example.
Thanks & Regards
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
do you have a screenshot or an excel sample ?