Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a table :
Invent:
LOAD
Date,
custaccount,
dataareaid,
Enterp,
inventbatchid,
inventlocationid,
inventtransid,
itemid,
itemgroupid,
qty,
transtype,
transtypeName,
vendaccount
Resident InventTEMP2
Where itemgroupid = 'MM' and Match(dataareaid,'a','b','c','d','e','f','g','h')>0 and Date<=Today();
At the moment there is data for the last five years. qty is number (quantity), other fields are dimensions
qty shows movement, but what I need is balance. For each date, for each dimension. So - at the moment to get balance in chart I have to sum every movement for last 5 years. This is really slow and date dimensions are not fully useable.
The only solution what I can image is to calculate balance in script. But how to do this - I dont have skills for that 
The important thing is, that there is possibility that within one date can every dimension and their combination be used more than once.
Thanks in advance