One of my applications is presenting an inconsistency with a Pivot Table. I have a field, called 'Month', which is associated with the field 'Quarter' and is used as a Dimension in the chart . This field is placed in a List Box for selections.
When I select a Year (2009, for example), the Pivot Table shows a Number for every Month. It looks like this:
Then, when I actually make a Selection for the Qaurter (Q1, for example) obviously the chart is reduced to show only the associated months, but the numbers change, as you can see in this image:
Any ideas why this might be happening and how can I fix it?