Compare pivot table summarized data to norm data?

Question

I've created a pivot table to analyze test scores from a set of students. I have a table with the norm scores for this test. Is it possible to create a Pivot chart that displays the norm scores beside the pivot table values regardless of if I use slicers to filter the data down? In essence, I would like to pin the norm scores so that they show at all times.

Answer 1

1.Add to data model.

2. Create relationship.

3.Result

Answer 2

Could you share us a file to test?

You can upload to OneDrive or DropBox. Then post a link here.

Here is an example file. Within the file, you'll notice that only the Reading test scores are showing on the pivot chart, even though other courses are available. I would like to pin the reading norms from the "MAP Norms" sheet to this chart. Note that I only want to add the "Fall INTL" and "Fall UAE" columns from the "Reading Norms" table to the chart since the source data is also fall and the chart is only for reading. I'd duplicate the process for the other test courses to make more sliceable charts.

Answer 3

Could you share us a file to test?

You can upload to OneDrive or DropBox. Then post a link here.