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



      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