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.