0

Annual cumulative

Jet Reports Historic Posts

January 09, 2013 12:38

None

Follow

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).

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

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts January 09, 2013 17:50

  Hi Grega,
  
  It looks like you are using a pivot table here. Where is your actual data coming from? Did you use NL(Table) with Jet to get this? Did it come from Jet Enterprise via a cube data source?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts January 10, 2013 11:16

  Hi,
  
  Yes 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.
  
  Br,
  Grega

• 0
  
  Jet Reports Historic Posts January 10, 2013 21:56

  Grega,
  
  Please post questions regarding Jet Express in the Jet Express community site here:
  
  http://expresssupport.jetreports.com/index.php
  
  Thanks!
  
  Regards,
  Hughes