Forum Discussion
Add Measure Classifications to Column Field Well
Hi all,
I'm trying to group the measures in the matrix visual shown below (labeled 'Current' / 'Prior') by the groupings circled in red ('Global Female' / 'Global Male' / 'US Non White' / 'White'). Is this possible? I currently have these set up a text boxes, but the users will want to see these column groupings in the exported data table, so I need to add groupings to the 'Columns' field well.
v-achippa please remove this topic, this was not the solution I needed and I ended up going a different direction.
9 Replies
Hi garynorcrossmmc ,
Are this based on a column on your model or on a classification of each measure?
If you have a measure for each of the calculations using a filter on your table the best option is to have a single measure for Current and Prior and then use the column you use has filter on your measures to be the columns of your matrix this will automatically give you the filter you are looking for.
Can you explain hoe you built the matrix so I can point you to a more accurate option.
hi MFelix,
These are classifications of existing measures within the model. I realize that the scenario you mentioned is ideal, but it will not work for this user requirement.
The matrix is built like this. There are 2 dimensions in the 'Rows' field well and 8 measures in the 'Values' field well. They are all labeled Current or Prior, but they are 8 separate measures.And how are the measures calculated? Are they all similar but with different filters or are they more complex?
Can you provide the syntax for some of them just to check
v-achippa please remove this topic, this was not the solution I needed and I ended up going a different direction.
Hi garynorcrossmmc,
Thank you for the response, if you have found any solution, I request you to please post it here and kindly mark it as accept as solution so that other community members will find it more easily.
Thanks and regards
Anjan Kumar Chippa
