How do plot the percent of a subgrouping in Spotfire

If we wanted to plot the percetage of fruit in each store by all fruit in that store how would we do that in Spotfire?  For example, how would we plot for store 2 the % of all fruit for store 2 that are peaches?  We were unable to figure out how to do this so we did a work around.  We did the calculations in excel then brought the % column in for each store into Spotifire without any further calculations.  

  Store 1 % Store 1 Store 2 % Store 2 Store 3 % Store 3 Store 4 % Store 4
Apples 5 17% 4 15% 8 22% 9 29%
Bananas 5 17% 4 15% 1 3% 4 13%
Pears 2 7% 6 22% 3 8% 5 16%
Grapes 5 17% 2 7% 8 22% 6 19%
Peaches 7 23% 7 26% 9 25% 5 16%
Oranges 6 20% 4 15% 7 19% 2 6%
Totals 30 100% 27 100% 36 100% 31 100%

 

(1) Answer

Login