That's a good point! Sorting the data table by the % column doesn't change the display order of the bars. I don't know if there is another way??
So, plan B. Back to the pareto plot. There is a "weight" role in the pareto plot dialog. You can use this role to adjust for the fact that the different counts are derived from different size totals. Create a new column and call it something like weight. Assign the following formula
weight = 1 / total
(or weight = 100 / total ) depending on whether you want fractions or percentages.
Assign column 'name' to 'y,cause'
Assign column 'weight' to 'weight'
Assign column 'count' to 'freq'