Require help on Confusion Matrix (pivot table) filter

Anonymous — Tue, 27 Feb 2018 09:28:01 GMT

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?

topic Require help on Confusion Matrix (pivot table) filter in App Development

Require help on Confusion Matrix (pivot table) filter