It looks like you set everything up properly, but I think there is something going on with
the data or the filters:
I'm not sure why, but it looks like things were getting thrown off because
[Score] was coming back as Null for the two "Enigszins..." Pivot Field Values.
Just to check, when I forced them to have a score, it lined up properly.
Please see screenshot below and workbook v18.1 attached in the Forum Thread.
283073divergent.twbx 587.8 KB
I'm glad the zero is aligning better.
Hmm. I'm not sure what would have affected the Pivot.
Just to clarify, the problem is on your DataSource tab
in that it is not allowing you to add more fields to the Pivot?
Or is it that the Pivot Field Name filter is not responding to changes
in selection? Would be grateful if you would post a screenshot
of the problem.
Good news! The pivot problem is fixed! Thank you for your tips!
But now I want to add the averages on the chart with dual axis but it calculates wrong averages... I hope there is nothing wrong with the calculations I made.
I made a new discussion for it.
Thank you already so much for the insights!