Displaying Percentage Sign in Crosstab

0

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..

asfandyar.khalil's picture
Joined: Jun 8 2017 - 6:14am
Last seen: 2 years 3 months ago

1 Answer:

0

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. 

reportdev's picture
1232
Joined: Oct 12 2015 - 12:05pm
Last seen: 2 months 1 week ago
Feedback