Jump to content
Changes to the Jaspersoft community edition download ×

Problem with percentages values into crosstab


2004 IR Help

Recommended Posts

By: asulis - asulis

Problem with percentages values into crosstab

2005-12-16 00:45

Hi,

I used the new JR's crosstab functionality in ordar to create a report with one field into rows and one into columns. I magine I have three different values into rows, for example, and six into columns. I have the totals groups for rows and columns also.

My problem is that I have to put in each cell not the real value, but the calculated percentage value, referred to the total I have in each row. So for each column I have to "store" the total, in order to use it to calculate percentages.

i couldn't find the way to calculate and store totals for each column. Does someone knows how to solve this ?

Thanks in advance

Alessandro

 

 

 

 

By: Lucian Chirita - lucianc

RE: Problem with percentages values into cros

2005-12-19 01:09

Hi

 

Currently crosstabs support percentage out of the grand total only. Support for other percentage calculations will be added to future releases.

 

However, you could use a trick to show percentages out of a row total:

- pass as a parameter to the crosstab something that you can use to store the row total value

- set totalPosition=Start for the column group so that you can save the total value.

- in the total column cell, place the value inside the holder.

- in the row cells, retrieve the value from the holder and use it to calculate the percentage.

 

HTH,

Lucian

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...