calculating proportion of sales in powerpivot

1
votes

I have a powerpivot table that looks like this:

Product, Units_sold, Year
A         10         1990
A         5          1990
B         12         1900
C         50         1900

I want to create a calculated field for the contribution to overall sales of each sale, e.g. in this case divide every number by 77.

How can I do that in Powerpivot?

1
excelpowerpivotdax
pnuts, the dataset is many different stores monthly sales data and so many products have multiple entries per month – oli5679

1 Answers

1
votes

Use this formula for your calculated column:

=[Units_Sold]/SUM([Units_sold])

Rename your column and choose formatting from the Home menu.