Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.