I currently have a set of 12 pivot tables that I display based on a prompt. So the user simply clicks on a 'View By:' dropdown and chooses which table to view. This was accomplished through simple 'dummy tables' and a presentation variable.
My question: Can I set up a similar prompt to change the row values in my pivot tables? For example, my row values are currently annual (12, 24, 36, ...). I would like to give the user the option to view the data on a quarterly (3, 6, 9, ...) and monthly (1, 2, 3, ...) basis.
Can I add a second 'View By:' dropdown so the user can select both the table, and row values the table is displayed on?
I was making this much more difficult than it needed to be. The solution is to create Groups for the different buckets of values I was referencing ((1,2,3,...), (3,6,9,...), (12,24,36,...)). Then simply set the corresponding column filter to Is Prompted and add the newly created Groups as Choices to your prompt's choice list.