You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Conditional Suppression doesn't work with CellValue

Accepted answer

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) .

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!