Forum Stats

  • 3,836,844 Users
  • 2,262,198 Discussions


Dashboard Prompt - Variable - Populate/Calculate column in Pivot Table

1. I have a need to store the values of three prompts (Year, Quarter and Month) in my dashboard prompt, So a 'column A' (calculated value/measure) can be dynamically populated in my pivot table based on the users chioce.

These prompts have to be multiselect prompts as the user may opt for 2 or more years/ quarters / months etc.

I don't think Presentation Variable would work as I have to use multiselect prompt, I have been trying Non-System Session Variables & dynamic repository variables- but could not get it to work. I am thinking only of using one of the three variables (session/dynamic/presentation) so far, is there a better way to tackle this?

Any help/pointers would be much appreciated, thanks
This discussion has been closed.