CODEWITHSUNDEEP
excelpowerpivotdax
oli5679
oli5679

Reputation: 1749

calculating proportion of sales in powerpivot

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?

Upvotes: 1

Views: 94

Answers (1)

Rory
Rory

Reputation: 969

Use this formula for your calculated column:

=[Units_Sold]/SUM([Units_sold])

Rename your column and choose formatting from the Home menu.

Upvotes: 1

Related Questions