Forum Discussion

Kayla2020's avatar
Kayla2020
Frequent Visitor
2 years ago
Solved

Apply filter to disconnected tables

Hi,

I have a matrix table based on dept and cost.  There are two disconnected tables(based on project) used in the matrix to return dept costs for selected projects. I want to create a slicer for country and cluster to filter the disconnected tables i.e if a country and cluster are selected, the disconnected table returns projects available in the selected country and cluster. 

Please how do I achieve this? Also, find attached the file.

Thank you.



projectdeptclustercountrycost
Project AHR1France5700
Project bLogistics1Poland7487
Project cProduct design2France7207
Project dTransport1Turkey7374
Project eHR1UK13018
Project fLogistics2Poland10117
Project gProduct design2Turkey6348
Project gTransport2France8902
Project hHR1Poland6061
Project jLogistics2France10677
Project iProduct design3Turkey6952
Project kTransport3UK7970
Project fHR1Poland10940
Project nLogistics2Turkey6979
Project mProduct design1Turkey11587
Need Help
Show and Tell
  • ThxAlot's avatar
    ThxAlot
    2 years ago

    Based on your description, TREATAS() would come into play.

2 Replies

  • ThxAlot's avatar
    ThxAlot
    Icon for Super User rankSuper User
    2 years ago

    Based on your description, TREATAS() would come into play.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI Kayla2020,

    You can add variable to use values function to extract the filter effect from the target table and manually use this in your calculations expressions to apply filter effect from disconnected table.

    Regards,

    Xiaoxin Sheng