Question:
Hi all,
I need to create a query that has the following data. Fiscal year goes across the columns with the key figure sales dollars.
1/2004 2/2004 3/2004 4/2004 ...... 12/2004
sales 10 13 15 12
Ttl 10 23 38 50
My question is, how do I create the total line? I am using 0fiscper as a selection, the user can enter in a from and to period range. I just need to keep a running total.
Thanks for any help you can provide.
Answer:
i don't think you can make the total 'running', but a workaroud: add the same key figure as a second row in your query, right-click, properties, and flag the "Cumulated" checkbox...
Let us know is this solves your requirement.
Answer:
That worked perfectly. I really appreciate your help on this!