Forum Discussion

DylanSandry's avatar
DylanSandry
Frequent Visitor
2 years ago

Grouping matrix columns using custom measures

Hello,   I've been destroying myself trying to figure this out and I wonder if someone can help. I have the following table (Simplified to get to the root of my problem): Job Product Price ...
Need Help
DylanSandry's avatar
DylanSandry
Frequent Visitor
2 years ago

That's worked perfectly thanks!

 

Just a follow up question. Is it possible to show and hide certail values based on matrix columns? I want to also add averages after the TotalPrice and TotalCount sections, so it will look like this

 Today ThisMonth ThisYear MonthAverage YearAverage 
ProductTotalPriceTotalCountTotalPriceTotalCountTotalPriceTotalCountPricePerDayCountPerDayPricePerDayCountPerDay

 

I can create the second section of matrix columns with a couple new measures and altered switch statements, but how can I hide the values that dont correspond to that section of the table? (Hide TotalPrice, TotalCount from the MonthAverage and YearAverage sections and vice versa).

 

Cheers.