Hi,
I've created report for example from date A (7.1.2013) to date B (9.1.2013). This dates are user defined.
I have two columns: Quantity Sold and Actual amount of Sales.
These two columns repesents data from 7.1 - 9.1.
I've would like to have two additional colums for annual comulative. I wuold like to have
Quantity Sold and Actual amount of Sales to show me data from 1.1.2013(fixed date) to date B (9.1.2013).
I'm using a pivot table and Jet express connected to Microsoft dynamics NAV(ERP). Data is coming from table witch I get it with Jets express.
Is it possible to make such query with Jet(How)? Or can I do this with Excel functions(How)?
Here is the picture of my report.
Thanks for answers.
Br,
Grega
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello Grega -
While I am not a Report Designer, depending upon the tables you are accessing using Table Builder and how the data is present in your database, you may be able to access that data using Flow Fields and/or the Sum Fields:
-HP
Please sign in to leave a comment.