Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Different Values from Different tables based on slicer

Hi all,

 

I want to create the chart and score cards where the values should show from different tables based on users selection. For example, if I chose one type from the slicers, the data should show from that specific type table. Do I need to append all these tables to make it work? 

 

Thanks in advanced.

 

Yanmin

  • Hi,

    You should append the tables and there should be a column in that table of Type so that when you click on a certain type then only those rows are considered in your calculation.

2 Replies

  • Hi,

    You should append the tables and there should be a column in that table of Type so that when you click on a certain type then only those rows are considered in your calculation.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

    Sure, I will do so. Thank you.

     

    Best Reagrds,

    YanMin