Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to hide pivot table with multiple expressions and each expression has conditional.I want to hide it when there is no data to dispaly (empty)??
thanks in advance
You can do the following:
1. In the chart's "Layout" option - put a Condition for your chart to be displayed
2. Add a dummy expression (just add "1" to the Expression's definition)
a. Make sure this dummy Expression is "Enabled", but "Hidden" (in Chart's Presentation tab)
Regards,
Vladimir