4 Replies Latest reply: Feb 19, 2013 12:33 PM by Muhammad Altaf RSS

    Comparing sum further within dimension

    Muhammad Altaf

      Hi

       

      IDUserNamePlanedActualDr
      1Khalid21A
      2Khalid33B
      3Khalid43C
      4Khalid44D
      5Khalid40E
      4Khalid43D

       

      I have pivot table

       

      UserName Sum(Planed) Sum(Actual)  in thir column I want the number of count of Dr whose Sum(Planed) <=Sum(Actual)

       

      how can I achieve this.. sample files are attached

       

      thanks in advance.