Forum Discussion
Harry_Tran
Helper III
4 years agoHow 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
Community 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