Inconsistency in Pivot Table

[mike_garcia]

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?

Any help is greatly appreciated. Regards,

Mike.

[Oleg_Troyansky]

Mike,

It would be easier to trouble shoot if you could post an example (perhaps a subset of your data or scrambled data...)

As a suggestion - add Quarter as a Dimension to your Pivot table and see what happens.

cheers,