Excel Power pivot measure

[eajustin15]

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.

[cgc17]

It might be better to create it as an attribute (a new column) rather than a measure so that you can use it to filter. There are a couple of ways to do this when in the PowerPivot window.

Option 1: Go to the far right of your dataset (to the first empty column), click in the top row of the first empty column and type =if(your formula here). When you are finished with that, right click on the column name and click rename column to set the name of the attribute.

Option 2: At the bottom of the PowerPivot window you will see a second grid under your data grid. This is where you can enter formulas for new attributes. Simply type "NameOfNewColumn:=if(your formula here)" without the quotes.

Hopefully this helps.