Forum Discussion
Matrix hierarchy grouping not showing data
Hi everyone,
I'm having trouble grouping data in a matrix. The matrix has two levels of columns, and a measure as values.
As you can see, with both levels deployed it shows data correctly. Trouble comes when I group up a level, it won't show any data. Like if there was something wrong with source data.
Here's a screenshot of the dataset, so you can see hierarchy has sense.
Congelado -- groups next 2 weeks.
Semiliquido -- groups from 2-6 next weeks.
Liquido -- groups from 7-8 next weeks.
Middle column is just for ordering purposes.
My goal is to get the average of the weeks im grouping. That's the simplest way I thought of doing it, maybe there's another way... creating another measure...
Any advice?
8 Replies
Could you not put week of year in the row value?
Is there some reason that would not work for you?
Ah ok.
I thought that if you put Estado in rows, and weeks underneath it, it will give you the sum of variances for each week, and you could change it from sum to average.
