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

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

      • 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