Drill trough on cell granularity

[Ritaf1983]

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 presented in a matrix with categories on each row
Daily and monthly amounts calculated in two columns.

He is looking for a way to make each entry into a more detailed table on row transactions granularity.

By using the "drll through" option
In this case, he does not get the desired result since he reaches tables that are only filtered by category
He also wants a breakdown of the cell (combining the category and the calculated column).
Is there a solution to this?

[MohammadLoran25 · Accepted solution]

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