I have a report with Accounts in the Row Axis and a combination of Entity, Time and Category in the Column Axis. The Entity Selection in the Column Axis is dynamic – in other words users can select “base members”, “dependents”, “children”, or “member only”. This area of the report is hidden completely.
Now, I should create local members to calculate variances for each Entity displayed in the hidden section (this variance could be between 2 time periods or 2 categories). Does anyone know how to make these local members expand with the Entity? In other words, if the user selects “base
members”, the variances should be calculated for each base member of the Entity, and if the user selects “member only” only 1 variance should be calculated and displayed.. Any thoughts?
Please note – We would like to avoid using VB if possible.
Thanks in advance for your time and help!