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 can't sort on the columns.

So instead I create different measures for each of the regions I want to report.

I put them all in a table and then everything works fine.

 

Now I want to create one drill through for the different measures in the sales table.

However this seems impossible. I just can't give the filter context (Region) through to the drill through page.

 

If someone knows a trick, feel free.

I know the way to do it is using a matrix, with the region in the columns properties, but then I can't sort.

 

Thanks in advance.

Frank

Need Help

6 Replies

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

    What do you mean when you say you can't sort the columns? 

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

      Hi,

       

      tex628 : I mean I can't sort the values in the columns of a matrix by clicking on the column header, like you can in a table.

       

      Frank

      • 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