Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Conditional Suppression doesn't work with CellValue — Cloud Customer Connect
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!