HI all,
I have a pivot table with data grouped into months going across and into sales or purchases going down. I want to add a running total (At grand_total level only) that shows closing balance for each month.
I know the Opening balance but want to add sales+purchases+previous months closing or my opening balance figure in case of the first month.
So far I have been able to create a calculated item at this level that will add sales+purchases for each month to give me net-movement. I created this item as Name=NetMovement formula=Sales+Purchases
I then tried to usecreate Name=Balance Formula=NetMovement+Balance[-1]
The [-1] doesnt seem to work on an item.
Any thoughts on how to achieve this?
I have a pivot table with data grouped into months going across and into sales or purchases going down. I want to add a running total (At grand_total level only) that shows closing balance for each month.
I know the Opening balance but want to add sales+purchases+previous months closing or my opening balance figure in case of the first month.
So far I have been able to create a calculated item at this level that will add sales+purchases for each month to give me net-movement. I created this item as Name=NetMovement formula=Sales+Purchases
I then tried to usecreate Name=Balance Formula=NetMovement+Balance[-1]
The [-1] doesnt seem to work on an item.
Any thoughts on how to achieve this?