Want to two show two tables having data with current month and past month in drill through

[Anonymous]

Hi

My data source is SSAS, Below is the scenario in which I need to show data  in drill through in two different table .

fact Table

weekNumber          Data

2020 07                          A

2020 07                         B

2020 07                          C

2020 07                          D

2020 06                          E

2020 06                         F

2020 06                         G

2020 06                          H

In drill through I am passing current month 2020 07.

In drill throgh page I want below output

Table 1                                                                   Table  2

A                                                                                     E

B                                                                                     F

C                                                                                    G

D                                                                                    E

Can you please advice how to ignore drill through filter and show table 2

[Sujit_Thakur]

Please explain question I can surely help on this 

I'll be more than happy to help