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:
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?