1 of 1 people found this helpful
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!
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.
Working with Quartiles.twbx.zip 64.4 KB