I would like to create a measure that calculates the percentage in a cross tab.
I have a row called affected type which displays the count for the Service type and a column called parent category. I would like to calculate the percentage by dividing the grand total by sum of each service type or parent category, multiply by 100 and display on my crosstab.
I am new on jasper studio and currently stuck.
I have attached an example.