Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use Calculated Dimension
IF(Period = 'Q214', Period)
Select Suppress When Value is NULL
Where are you applying the logic? In the Expression, for a Dimension, in the Layout tab?
Thanks.
Hi Manish, that way I'd hidding everything, I do want to show the "headcount" columns for all the available periods
Hi Greg, I'm applying it to the expression
Can you share the file please?
Here you go
Is this what you are after?
Nope, this is it.... where QoQ is the delta between last Q (Q214) minus previous (Q114)
Hopefully - My response was helpful.