2 Replies Latest reply on Jun 21, 2012 11:15 AM by Tim Lens

Calculating % of students in each quartile - Bottom two quartiles below x-axis

I'm trying to calculate the % of students in each quartile and put the bottom two quartiles below the x-axis.

Without bothering with the x-axis, this wasn't hard. I put [Number of Records] in Rows and selected "Percentage of Column" under the Analysis tab.

Next, I was able to calculate the # of students in each quartile and put the bottom two quartiles below the x-axis using the calculated field [Counts by Quartile]:

IF [Quartile] <= 2

THEN [Number of Records] * -1

ELSE [Number of Records]

END

However, if I select "Percentage of Column" again, it goes haywire because of the negative numbers in the bottom two quartiles (they throw off the denominator).

Any suggestions? A sample file is attached.

• 1. Re: Calculating % of students in each quartile - Bottom two quartiles below x-axis

Hi Cole,

I think what you are referring to when you say it goes haywire is the labels on the bars? If this is the case, place sum(Number of Records) on the label shelf instead of Counts by Quartile. Then, right click on it and select Quick Table Calculations-->Percent of Total. Right click again and select Compute Using-->Table (Down). Then, right click on one of the labels and select Format... and format the labels as desired. I hope this helps!

-Tracy

1 of 1 people found this helpful
• 2. Re: Calculating % of students in each quartile - Bottom two quartiles below x-axis

I guess you also want your axis and bar heights to represent percentages, and not just the labels.
In that case you'll need to put your table calc before you do the multiplication ( * -1 )

See the workbook attached, I copied your calc and put the table calc inside already.
Hope that helps.