show totals but suppress values in pivot table

[#1]

Hi

I have a pivot table as shown below. What I need is to suppress the YTD column and just show the total.

[rwunderlich]

The way to accomplish this is define the YTD expresion as a calculated Dimension instead of an Expression.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[trdandamudi]

Sunny,

Brilliant...you always find a way to resolve the issue...

[#4]

Thanks a lot Sunny. But i think i was not clear on my requirement, my apologies.

What i am trying to do here is suppress the YTD column and just show the total for YTD column, whereas the service% stays the same.

[Anonymous]

sunny,

why we used total in the expression

i.e 1)before(total sum(sales)

2)column(total)

can you explain a little detail.

[Jbekhazi]

Has anyone found a solution for this yet? I am facing the same thing currently.

Any assistance would be greatly appreciated.