Forum Discussion

Harry_Tran's avatar
Harry_Tran
Icon for Helper III rankHelper III
4 years ago

How to get specific rows in a table based on selected row from another table

Hi,

I have a matrix and a table like below:

Summary Matix:

 

Detail Table

 

 

"Bad" bucket is equal to 1 + 2 + 4 + 5

"Total" = "Good" + "Bad"

 

Is there anyway that when I click to the "Bad" bucket of Store A ( number 7 ) from Summary Matrix, it will filter the Detail Table and show me the data of bucket 1 - 5. and it would do the same if I choose bucket "Total"

 

There is a "Bad" and "Total" bucket for my Detail Table, but I excluded them (visual level filter) because I do not want to see the duplicate data. Right now, when I click on "Bad" or "Total" bucket, the Detail table will be empty.

 

Thanks!

1 Reply

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support

    Hi Harry_Tran ,

     

    Are there columns such as "Total", "Good", "Bad" in your Detail Table? If they don't exist, how do you calculate them?

     

    Best Regards,
    Winniz