Hello all,

I am new to power pivot and would love some help with problem. Basically I am using power pivot to track client activity on a month to month and year to date basis and I group them in four categories: "Didnt return business", "return business and spent more", "new Business" and "return business with less spend". The data that I am bringing in looks like what i have below:

Month Client 2013 2014
Jan A $ 0 $ 100
Feb b $ 5 $10
MArch C $100 $0


I am able to bring the data in powerpivot and create a measure using an IF to group them in the buckets I want using the 2013 and 2014 values. The problem i am having is now i need to sort the new measure to only show me clients in the bucket that i want to see. is there a better way I can go about this. Can i sort a measure after i Create one? Any help would be greatly appreciated thanks.