I’d like to request the ability to have a parameter value vary based on the value of another parameter.
My specific use case is a pivot table whose grouping values change dynamically based on a parameter. We have created calculated fields, named Value1/Value2 whose values are set based on the parameter, and are used as the grouping values in the pivot. The problem is that we don’t want to display “Value1” etc as the column names in the pivot table, but instead would like to have the column names be what these values represent.
For example, if the parameter is set to “Geography”, Value1 is defined as the state and Value2 as the city. We’d like the ability for the column names to show as State/City in that scenario. If the parameter is set to “Date”, Value1 is defined as year and Value2 as month, and we’d like the column names to change accordingly. My proposed solution would allow us to create two new parameters named Header1/Header2 that will be used for the column names. Header1 would equal “State” if the grouping parameter is set to “Geography”, and it would equal “Year” if the grouping parameter is set to “Date”.