Help with percentages in crosstabs

[wahoyaho]

I only see the option for the percentage of grand total, is there anyway to make it a percentage of something else?

[Giulio Toffoli]

You can make a percentage respect each asingle row/column total.

 

I.e. to have the percentage of the single year respect to all the time use:

 

Code:

new Double($V{FreightSum_ShipMonth_ALL}.doubleValue() / $V{FreightSum_ShipYear_ALL}.doubleValue())

 

Or to have the percentage of each single month respect to the current year:

 

Code:

[code] new Double($V{FreightSum}.doubleValue()/$V{FreightSum_ShipMonth_ALL}.doubleValue())

 

 

Attached there is a sample you can run using the database shipped with JasperReports.

 

Giulio [file name=crosstab.zip size=8031]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/crosstab.zip[/file]

[wahoyaho]

Thanks for the fast reply, just a quick question, how can I make a variable that is total of each day?

 

For example, the first table in

http://www.fortinet.com/FortiLogdemo/file/Network_Activity.html

 

I can get the subtotal % values to show up correctly with Grand Total percentage provided in the crosstab options, but how can I get the % for the unclassified values?