Table Chart Expression to summarize all field values

[#1]

Hi Guys, I'm new in Qlikview and I'd appreciate a lot if somebody could help me to configurate this chart properly:

I want to create a Table Chart, that is a basic Inventory Rollforward.

I'm using the month field (box) of the transactions table, to generate the RollForward for every month I want.

The problem is that instead of that report is generating this:

The Beg. Balance and Final Balance are calculated incorrectly.

What I need to know is which expression should I use in these two columns, to give me the TOTAL balance separate of the Transactions Generated every month (Purchases, Install, Repairs) which belong to the Month Selected.

Thanks in advance for any help provided

Jon

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling.