Require help on Confusion Matrix (pivot table) filter
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?
