7 Replies Latest reply: May 20, 2016 7:12 AM by N G RSS

    Pivot table - not 'fully' pivoting

    N G

      Hi All,


      I think I must be missing something obvious here :-(


      I created a pivot, with 2 dimensions and 3 expression (See pic 1):-


      Dims = Branch and SGR (Product Subgroup)

      Expr = Various stock figures


      I am simply trying to get the 2 dims down the left with the 3 expressions across the tops (see pic 2), but every time I have the 2 dims on the left it always drags the expressions to the left also, I cannot get the expressions to the top 'on their own'.


      What am I missing please ?



      BobReport 1.jpgReport 2.jpg