Conditional Suppression doesn't work with CellValue
I'm building a report that will have four columns:
- base scenario ("Base") - data
- comparison scenario ("Comp") - data
- their variance ("Var") - formula
- and % of variance ("% Var") - formula
Accounts are in rows, Entities and Products are in POV.
I want users to be able to select the view: either to see all four columns, or only Base and % Var. To enable it, I have two accounts: one with member name "Hide," the other - with member name "Show." Row #4 has a prompt with Hide and Show as options. Besides four columns with data and formulas, there is a fifth column that has a formula "MemberName ("Account", 4) .