Displaying Percentage Sign in Crosstab

[asfandyar.khalil]

I have the below data in an excel file.

Sites	Infections	Count
LEO	# Infections	1
MGH	# Infections	2
VIH	# Infections	8
LEO	Total Treatment	12
MGH	Total Treatment	45
VIH	Total Treatment	515
LEO	% Infections	833%
MGH	% Infections	444%
VIH	% Infections	155%

 

When I want to display this in Crosstab, it get displayed as below.

                                                       LEO                MGH                     VIH

 # Infection                                        1                       2                          8

 Total Treatment                                12                     45                        515

 % Infections                                      8,33                 4,44                     1,55

 

I am satisfied with the results but I can not display % sign in %Infection row of the crosstab.

NOTE: I am doing sum calculation in crosstab.

If anyone of you has any solution then please share that here..

[reportdev]

On the Crosstab field Text Field Properties, you should be able to see Pattern Properties.

Click on the 3 dots button and select a Percentage Pattern.

It should add a % symbol to the crosstab value.