Hi, I have a pivot table that has user count and week-over-week metric columns populated. Is there a way to hide the value column that contains the wow metrics for all weeks and just populate the latest one?
There is a workaround, you can create a calculated field WoW-New adding a ifElse condition and a field to indicate whether it is the last row
For instance, ifelse(LastRow=1, WoW, 0)
Then use conditional formatting, if WoW-New = 0, make the background color and text color to be white. So, they looks like invisible.
Not a perfect solution, but visually it can hide the value of other rows
1 Like
This still makes it look like having an additional blank column. Can we hide this using the a date parameter?
Got this resolved by using Free form layout and hiding the WoW in visual no.1 and have them displayed in visual no.2.