Getting total sales for a category

[ppvtuser]

I have a powerpivot table that has the following columns:

product name, category, sales

I would like to insert a calculated column that calculate the total category sales. Example
product name, category, sales, total category sales
ipad, tablets, 5, 8
samsung tab 10.1, tablets, 3, 8
galaxy s3, mobiles, 2, 5
iphone, mobiles, 3, 5

how can i achieve that?

 

[MartinL]

Hi
What I did to create Rate of Sale was:
In the powerpivot screen
click on new measure
Enter the Table Name where your data comes from ie DataFile
Enter a random name for your new value ie TotSales
then in Formula enter

=AverageX(DataFile, DataFile[Value Sales]) / SUMX(DataFile,DataFile[Store Numeric Distribution])As you enter the Table name each time the fields will appear for you to choose
I know this does not completly answer your question but hopfully it will give you something to play with until another answer comes along

Martin

 

[masplin]

In the new column put

=CALCULATE(sum(Table1[Sales]),filter(table1,table1[Category]=EARLIER(Table1[Category])))

Mike