Calculate percent off another row in Jaspersoft server

[joshua.jackson]

Hello,

 

i am trying to figure out how to calculate percentages based off different rows. 

 

For example

My data looks like this:

	Team1	Team2	Team3	Totals
Ticket Count	100	50	200	350
% Of tickets	28%	14%	57%	100%
Number Resloved	90	50	100	240
% Resloved	90%	100%	50%	80%

 

Any help on how to do this would be greatly appreciated. 

[elizam]

Try using a table instead of a crosstab. You will need to have your teams as rows and your tickets as columns.  Then you can right-click on each column one at a time and create a custom field for that column.