1 Reply Latest reply: Nov 18, 2014 2:55 AM by Liron Baram RSS

    partial sum problem in pivot

    snehal mejari

      Hi Guys,

       

       

      Need ur help

       

      Cash App ExecutiveAllocation_Status 11/17/2014
      Anita GuptaClosed 80
      Anita GuptaReject 22
      Anita GuptaWIP 16
      Anita GuptaTotal 89
      Deepti.gokhaleClosed 37
      Deepti.gokhaleReject 23
      Deepti.gokhaleTotal 37
      snehal.patilClosed 72
      snehal.patilReject 23
      snehal.patilWIP 9
      snehal.patilTotal 79
      Total 205

       

       

      i'm having pivot table where i'm having expression as count(distinct allocation id) which you can see in  date column when i'm applying partial sum total for eas cash app executive it is showing wrong.for more clarification .PFA attached qvw