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

0

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                            

 

 

 

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

5 Answers:

0

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

Friendly User's picture
Joined: Oct 8 2009 - 5:59am
Last seen: 3 days 21 hours ago
0

Hi Friendly User,

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

RICE's picture
9
Joined: Jan 29 2016 - 11:38am
Last seen: 1 year 10 months ago
0

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. 

RICE's picture
9
Joined: Jan 29 2016 - 11:38am
Last seen: 1 year 10 months ago
0

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.

Friendly User's picture
Joined: Oct 8 2009 - 5:59am
Last seen: 3 days 21 hours ago
0

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.

RICE's picture
9
Joined: Jan 29 2016 - 11:38am
Last seen: 1 year 10 months ago
Feedback