1 Reply Latest reply on Mar 19, 2018 8:43 AM by Joe Oppelt

    Calculation across x & y axis of an Excel pivot table

    John Willcox

      Hi

       

      I am trying to re-create the calculated table beneath the pivot table in Excel below that uses both the x & y axis of stock being held in shops from warehouse in the same / other countries and / or a wholesaler

       

      Attached is a version of the spreadsheet that I am trying to re-create, I have color coded the calculations to make them easier to follow

       

      Any help would be gratefully received

       

      Thanks

      John