# Can anyone provide an example of how to create a crosstab with percentages?

Can anyone provide an example of how to create a crosstab with percentages?  Super easy in excel but can't seem to figure it out in Jasper.

Data
Type Color Count     Column Labels
Truck Red 15     Sum of Count         Percent of Row Total         Total Sum of Count Total Percent of Row Total
Truck White 30   Row Labels Black Blue Red White Yellow Black Blue Red White Yellow
Truck Blue 20   Car 20 30 10 20 20 20% 30% 10% 20% 20% 100 100.00%
Truck Black 20   Helicoptor 90 2 2 2 4 90% 2% 2% 2% 4% 100 100.00%
Truck Yellow 15   Submarine 10 10 5 10 65 10% 10% 5% 10% 65% 100 100.00%
Car Red 10   Truck 20 20 15 30 15 20% 20% 15% 30% 15% 100 100.00%
Car White 20   Grand Total 140 62 32 62 104 35% 16% 8% 16% 26% 400 100.00%
Car Blue 30
Car Black 20
Car Yellow 20
Submarine Red 5
Submarine White 10
Submarine Blue 10
Submarine Black 10
Submarine Yellow 65
Helicoptor Red 2
Helicoptor White 2
Helicoptor Blue 2
Helicoptor Black 90
Helicoptor Yellow 4

9
Joined: Jan 29 2016 - 11:38am
Last seen: 1 year 10 months ago

Hello,

when you create a measure in crosstab you can choose the measure to be a percentage of some type, like percentage of Grand Totals.

https://www.screencast.com/t/SU5vDNLMC

Notice the percentage of option

16777
Joined: Oct 8 2009 - 5:59am
Last seen: 3 days 21 hours ago

Hi Friendly User,

When creating the crosstab I do not get an option of percentage calculation.   Am I overlooking something here?

9
Joined: Jan 29 2016 - 11:38am
Last seen: 1 year 10 months ago

Friendly User,

I found the percentage of type section for the measure; however the output shows 0% for everything.  If I set percentage of type to none then I receive the actual sum I'm looking for.

9
Joined: Jan 29 2016 - 11:38am
Last seen: 1 year 10 months ago

If you want to display both percentages and sum values then you'll need to create 2 measures. One will display the sum without percentage, the other will display sum value as percentage of grand total.

16777
Joined: Oct 8 2009 - 5:59am
Last seen: 3 days 21 hours ago

I found the percentage of type section for the measure; however the output shows 0% for everything.  Any way you can provide an example.  It doesn't appear this functionality is working correctly.

9
Joined: Jan 29 2016 - 11:38am
Last seen: 1 year 10 months ago