3 Replies Latest reply: May 20, 2011 2:43 AM by Paul Kelly RSS

    % of Total

    Paul Kelly

      Hi ...

       

      I am trying to achieve the following

       

      %ProductFamilyKeyProvSales% of Tot
      2UK50025.00%
      NUK150075.00%
      Total 2000100.00%
      3UK60046.15%
      NUK70053.85%
      Total 1300100.00%
      Total 3300

       

      Sales = sum(sin_Sales)

       

      How do I calculate the % Total based on the sub total for each %ProductFamilyKey

       

      I have tried playing around with the aggr function with no success so far.

       

      Any assistance greatly appreciated.

       

      Regards

      Paul