Hello all,
I used the pivot table chart to create the confusion matrix with the following data structure:
| x (row in pivot table) | y (column in pivot table) | score (measure in pivot table) |
|---|
| Doc A | Doc B | 0.8 |
| Doc A | Doc C | 0.6 |
| Doc B | Doc A | 0.9 |
| Doc B | Doc C | 0.4 |
| Doc C | Doc A | 0.7 |
| Doc C | Doc B | 0.1 |
Now I've a dimension that i would like to filter the data by and the dimension is year. I've another table that contains the documents details with the following structure:
| x | year |
|---|
| Doc A | 2017 |
| Doc B | 2017 |
| Doc C | 2018 |
However, when i inserted year as a dimension into a filter pane, it only filters the x dimension in the pivot table. (as expected)
An example is if i select 2017 in the year filter pane, the pivot table will show Doc A and Doc B on the row but still show Doc A, Doc B and Doc C on the column in the pivot table.
Is there any way i could select a value in the year filter pane and filter for both x and y in the pivot table?
