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
Hi Manish, that way I'd hidding everything, I do want to show the "headcount" columns for all the available periods
Where are you applying the logic? In the Expression, for a Dimension, in the Layout tab?
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.
I haven't found the solution Greg, that was just a manually cut image to show you what I'm trying to get.
Retrieving data ...