Forum Discussion

Goofr's avatar
Goofr
Icon for Advocate IV rankAdvocate IV
7 years ago

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...
Need Help
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

Wow, i didn't know that! :-) 

But if you put your region measures in a matrix without any column dimension you can still add a drill on row level:



I'm not quite sure if this is what ur looking for, it would be easier if you could post a picture of the desired outcome. 

/ Johannes

Goofr's avatar
Goofr
Icon for Advocate IV rankAdvocate IV
7 years ago

Hi,

 

The problem with the matrix is you can't sort, The problem with the table is you can't have a unique drill through page for measures with diff filters because it misses the dimension Region, which do you have in a matrix as column.

I want to sort and have one drill through page :)

 

So I was wondering if someone knew a trick to obtain this.

 

Frank

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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's avatar
      Goofr
      Icon for Advocate IV rankAdvocate IV
      7 years ago

      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!