I think there is an option how you could display the desired content without creating a special a table calculation. Just create a basic table that shows 'Geography', 'Product Type' and the 'Value Sales'. Then exclude the 'major multiples' (I understand the 'major multiples' are an aggregation of the different stores), after that you could just apply a 'quick table calculation' to 'Value Sales', in this case 'Percent of Total'.
Maybe this solution works as well for you,
Thanks for your input. Unfortunately I do not have all the aggregate parts to major multiples, so I cannot create a share from adding up the parts, and running a quick table calculation. I need to divide each accout by the major multiples value.
Since 'major multiples' is an aggregation of the other values, all values associated with it should represent the maximum value in the column 'Value Sales'. So the following formula might work for you:
SUM([Value Sales])/window_Max(sum([Value Sales]))
Place 'Product type' on columns, and 'Geography on rows, change the formatting to percentage, hide 'major multiples', show grand totals, and the result might be the one you were looking for.
Hope this is helpful,
Thanks, it works. Jon