I have a pivot table and in it i have a series of groups i am showing sales for. I am trying to show the unit sales by style and color within a group and the % to total of those sales. I know how to use the value/field settings and choose % of total, the problem is that it doesn't base the style and color % to totals on the group total number but rather on the total assortment % of total. this is resulting in diluted information.

Does anyone know how to do a % to total in the value fields by each group in the row labels?