showing last expression column in pivot

[Anonymous]

Hi, is there a way to hide all but one (last) column in a pivot table? Here's the screenshot, I just want to show the "QoQ" for Q214, and the simple conditional  Period='Q214' in the expression is not working, that way all the columns are hidden

[MK_QSL]

Use Calculated Dimension

IF(Period = 'Q214', Period)

Select Suppress When Value is NULL

[Greg_Williams]

Where are you applying the logic? In the Expression, for a Dimension, in the Layout tab?

Thanks.

[Anonymous]

Hi Manish, that way I'd hidding everything, I do want to show the "headcount" columns for all the available periods

[Anonymous]

Hi Greg, I'm applying it to the expression

[Greg_Williams]

Can you share the file please?

[Anonymous]

Here you go

[Greg_Williams]

Is this what you are after?

[Anonymous]

Nope, this is it.... where QoQ is the delta between last Q (Q214) minus previous (Q114)

[Greg_Williams]

Hopefully - My response was helpful.