I have a report that has Accounts, Products, and Entities in the rows, and Scenarios, Years, Periods, and in-report calculated variances in the columns. We use “Children of current POV” for Products and Entities; the same products and entities shall be applied for all accounts.
The account selections are supposed to be dynamic, with Prompts allowing to make selection during the report run.
There are three different types of accounts that have different variance calculation rules and formatting rules, so we can’t select all accounts at once: we need three different selectors.
Unfortunately, when I create three separate rows for different types of accounts, or three separate grids, it only gives me the first prompt, and after I make selections it gives me this error message for all three prompts: