12 Replies Latest reply: Aug 15, 2018 2:23 AM by Yihao Zhang RSS

    Pivot Table expression

    Yihao Zhang

      Hi, there. I want to make a pivot table like that. There are only 2 dimensions 'Minifabrik' and 'Day'.

       

      MinifabrikDayWeThFrAvgTarget
      MF1%%%%%
      MF2%%%%%
      MF3%%%%%
      MF4%%%%%

       

      I made a table but not finished.

      3.PNG

      Values for column We Th and Fr are  Sum(A)/Sum(B).

      Can u help me to write expression for column Avgerage and Target?  Target = avg(T)

       

      Thank you.

       

      data source

       

      Load  Minifabrik,

                Day,

                A,

                B,

                T

      From xx.qvd