I need to hide 1 column that will ALWAYS have 0.00 as a result so I do not have to create two worksheets so only the remaining 5 columns are aligned and shown on a dashboard. How do I hide just the yellow highlighted column?
Thanks in advance!
-Mark
Worksheet 6 columns
Dashboard result 5 columns using 2 worksheets to overlay the column with 0.0
Aug 17, 2017 7:40 AM
Right click on the column header and select Hide.
Aug 17, 2017 8:39 AM
Hi Mark,
This is actually little bit tough request.
I mean hide the unique combination of Dimension x Measure is tricky.
In the below sample, try to hide Yr 2016 delta.
To define "uniqueness" of this specific column, we need to duplicate all the data source.
Make column unique.
Hope this helps.
Thanks,
Shin
Aug 17, 2017 9:15 AM
Hi Chuck,
The Header in question is the one
combining the unique Measure Name
with the unique Dimension value.
No way to hide this combo without distorting a viz.
What would work is making Headers from a Set.
This is basically what Shin had suggested.
Yours,
Yuri