Forum Discussion
Goofr
7 years agoAdvocate IV
Drillthrough from Table on Measure with Filter
Hi, I have a Sales table with dimension 'Region' linked to it. There are many different regions, but I want to report just a couple of them. Now I don't want to use a Matrix visual, because you...
tex628
7 years agoCommunity Champion
You can sort the matrix as long as you dont have any dimension in the column section. Which means that you can have a row level drill and still be able to sort.
Goofr
7 years agoAdvocate IV
Ok, I didn't know that.
However I still have the same problem with the drillthroughs.
In the matrix I now have different measures (Filtered on different Regions) but the filter inside those measures can't be read in the drillthrough page. And I don't have that dimension in the matrix either, so it's not passed through.
So I have to create a drillthrough page per measure...
Thanks anyway!