Forum Discussion

AshDil's avatar
AshDil
Helper V
5 years ago
Solved

Switching Dimensions based on slicer selection

Hi, I have 3 tables as follows: Table 1: Report A B Table 2: Segment  Amount North 100 East 200 South 300 West 200 Central 400 Table 3:   Segment  A...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi,  AshDil 

    As Ashish_Mathur said , you have to consider integrating the data from Tables 2 and Table3.
    I have created a sample file for your reference. Hope it will help you.

     

    If you consider this thread closed,please mark the helpful replies or add your reply as Answered to close this thread.Other community members will easily find the solution when they get the same issue.

     

    Best Regards,
    Community Support Team _ Eason

AshDil's avatar
AshDil
Helper V
5 years ago

Hi sevenhills ,

My requirement is near to above suggested one but not complete solution because in above mentioned the data is coming from same table but in my case the data comes from 3 different tables. So, Please suggest me to do.

Thanks,

AshDil

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi,  AshDil 

As Ashish_Mathur said , you have to consider integrating the data from Tables 2 and Table3.
I have created a sample file for your reference. Hope it will help you.

 

If you consider this thread closed,please mark the helpful replies or add your reply as Answered to close this thread.Other community members will easily find the solution when they get the same issue.

 

Best Regards,
Community Support Team _ Eason