Jump to content
We've recently updated our Privacy Statement, available here ×

perez08_erich

Members
  • Posts

    1
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Posts posted by perez08_erich

  1. Hi I am new in this and  i would like to ask how to produce annual Growth rate using crosstab?

    to make it simple ,in my database it contains the Year, Item,quantity like this:

    YEARITEMQUANTITY
    2014Book 35
    2014Pencil56
    2015Book67
    2015Pencil50

     

     

    now in my report query i filtered it by "YEAR". By creating crosstab i produced something like this:

     $F{Year}Total Quantity Measure
    $F{Item}$V{Quantity_measure}$V{Quantity_measure}
       

     

    which shows something like this

     20142015Total
    Book3567102
    Pencil5650106

     

    I want to calculate the annual growth rate but cant manipulate the datas by Year as it only produces the total of both years, is there any way i can use the formula for annual growth rate in crosstab?

    Can anyone give me a sample template or any info on how to do it? Thank you very much. I want to produce a report output like this:

     

     20142015Growth Rate
    Book356791.42%
    Pencil5650-10.71%

     

×
×
  • Create New...