Forum Discussion
Community ChampionMatrix Manipulation
smpa01 you can easily achieve this with calculation groups.
here is a high level of how you will do it, assuming you have two measures called "Measure Fact 1" and "Measure Fact 2"
- create a calculation group with two calculation items, let's call those fact 1 and fact 2
- in fact 1 calculation item, you will check if the selected value = month 1 then return blank else return "measure fact 1"
- in fact 2 you will always return "measure fact 2"
on matrix visual:
- category on rows
- month and column from new calculation group
- in value, use any one measure
Please try and let me know if you run into any issues.
Cheers!
Super Usersmpa01 you can easily achieve this with calculation groups.
here is a high level of how you will do it, assuming you have two measures called "Measure Fact 1" and "Measure Fact 2"
- create a calculation group with two calculation items, let's call those fact 1 and fact 2
- in fact 1 calculation item, you will check if the selected value = month 1 then return blank else return "measure fact 1"
- in fact 2 you will always return "measure fact 2"
on matrix visual:
- category on rows
- month and column from new calculation group
- in value, use any one measure
Please try and let me know if you run into any issues.
Cheers!
