Forum Discussion
Grouping parameters into matrix
I am hoping someone can help me.
I have a parameter set up with hundreds of measures. Within the parameter table I have categorized each measure by the type of measure, the time frame of the measure and the time group of the measure.
For example:
| Measure Name | Measure type | Timeframe | Time Group |
| Current Year Sales $ | Sales $ | Yearly | Current |
| Last year Sales $ | Sales $ | Yearly | Prior |
| Yearly Sales Var $ | Sales $ | Yearly | Variance |
| Yearly Sales Var % | Sales $ | Yearly | Variance % |
| Current Year Credits $ | Credit $ | Yearly | Current |
| Past year Credits $ | Credit $ | Yearly | Prior |
| Credits Var $ | Credit $ | Yearly | Variance |
| Credits Var % | Credit $ | Yearly | Variance % |
| Current Month Sales $ | Sales $ | Current Month | Current |
| Current Month Past year Sales $ | Sales $ | Current Month | Prior |
| Current MonthSales Var $ | Sales $ | Current Month | Variance |
| Current Month Sales Var % | Sales $ | Current Month | Variance % |
| Current Month Credits $ | Credit $ | Current Month | Current |
| Current Month Last year Credits $ | Credit $ | Current Month | Prior |
| Current Month Credits Var $ | Credit $ | Current Month | Variance |
| Current Month Credits Var % | Credit $ | Current Month | Variance % |
I want to be able to pull this data into a matrix, with Measures as the values, Time Group as the column headers, Measure Type as the row headers and Time Frame as the parameter for user selection. However, when I put the measure in the values, it brings every measure into the to Time Group.
Example end product expectation:
| Current | Prior | Variance | Variance % | |
| Sales $ | 1234 | 4321 | -3087 | 29% |
| Credit $ | 1234 | 4321 | -3087 | 29% |
Any help would be greatly appreciated.
1 Reply
ktimbers , You need to use the calculation group for that. I have setup an example there
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
