JasperSoft Studio Crosstab Total Calculation
Posted on May 7, 2015 at 3:21am
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.