RangeSum with Multiple Dimension

[adeagts]

Hello,

I was create pivot table with 3 dimensions (MonthName(Date), Date, ProductGroup). I was create RangeSum with special conditions to see acummulation balance. When i collapsed Date to be MonthName(Date), acummulation balance is showed correct calculation, when i expanded only one month to see Daily balance, the acummulation balance is still showed correct calculation. But when i filtered 2 value in ProductGroup (ex: FA8 and FA8/99), the accumulation showed incorrect number. The end balance accumulation show number FA8+FA8/99. I want the pivot table show partial end balance accumulation (EndT). Please help me?

[adeagts]

The formula of EndT is (Beg + Prod FG - CO FG - CO FGP), and accumulation for all month is showed.

The EndT at FA8 is correct. But EndT at FA8/99 is EndT of FA8 plus EndT actual of FA8/99 EndT. EndT of FA8/99 should be 927.