Jump to content

JasperSoft Studio Crosstab Total Calculation

vector vector

Recommended Posts

I've been experiencing some difficulty using the crosstab element in JasperSoft Studio:

I am displaying various data about specific stores' products, including stock levels, sales values as integers/floats, and gross profit as a percentage. The rows of my crosstab represent branches and the columns represent the relevant data pertaining to a product for each branch. The totals are correct for values such as stock level, since values like this one are simply summed and displayed. The gross profit percentage, however, presents a problem, in that I cannot simply sum up/count/average the individual percentages per product, per branch. Since my MySQL select obtains the relevant totals for me, I would like to use them directly. However, I cannot access my main dataset's fields from the crosstab.

I've spent hours trying to find a way to obtain the total gross profit percentage from my main dataset, but without success. The deadline for this report is looming, and I would really appreciate your help :(

In a nutshell, I want to display a field from my main dataset in my crosstab, without that field being a measure.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

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