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 ?

       

      Thanks

      BobReport 1.jpgReport 2.jpg