Forum Discussion

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago
Solved

Drill trough on cell granularity

Hello, It would be great if you could help me find a solution for my client. He is using a report server. Loading tables calculated in the source saves time. DAX is not used at all. Data is pres...
  • MohammadLoran25's avatar
    3 years ago

    Hi Ritaf1983 ,

    You mean only one of the calculated columns should be shown after drill through based on the selected cell?

     

    If yes, One way is creating 2 separate pages, and in one of them add "Category and Calculated column1" as Drill through fields on the page

    and add "Category and Calculated column2" as Drill through fields on the second page.

     

    Then the end user can select to drill through which one of above-mentioned options.

     

    If this answer solves your problem, accept it as a solution so others would find what they need easier.

    Regard,

    Loran