1 Reply Latest reply: Sep 27, 2016 1:15 PM by Sunny Talwar RSS

    pivot table sum(total) question

    Josh Chang

      Hello,

       

      I have a table like this

      WeibullInput.PNG

       

      A pivot table has lastShipDateYW and Time2FWeek as dimensions. The expression is the total count of unique subsetID

      WeibullIn.PNG

       

      I would like to know how to add a column which has total count of subsetID in lastShipDateYW and a row which has total count of Time2FWeek, like

      WeibullIn.PNG

      How to do it?

       

      thanks,

      Josh