6 Replies Latest reply: Mar 12, 2018 4:55 PM by Cengiz Eralp RSS

    Aggr in Expression question

    Mike Zhu

      Hi,

       

      I have the following inline table:

      load * inline

      [

      ID, Date, Status

      1, 8/3/2018, Existing

      2, 8/3/2018, New

      3, 8/3/2018, Existing

      4, 8/3/2018, New

      5, 8/3/2018, New

      6, 7/3/2018, Existing

      7, 7/3/2018, New

      8, 7/3/2018, New

      ]

      ;

       

      Please help to create the following pivot table:

      20180312a.PNG

       

      I am using the following expression for Distribution:

      count(aggr(Count(ID),Status,Date))/count(aggr(Count(total ID),Status,Date))

       

      But get 100% in all values in Distribution.

       

      Thank you very much.