Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to create a % from a single column value

Hi All,   I kindly need your help to solve my problem. Currently I have data like below table:   and i would like to create a report such as below template:     The problem that I ...
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
7 years ago

Create 2 measures

Gross Sales Amount = SUM(Table1[Gross Sales]) 

Contribution by SKU = [Gross Sales Amount] / CALCULATE(SUM(Table1[Gross Sales]), ALL(Table1[Type]))

Pull 'Gross Sales Amount' into the Values well of a matrix.

Pull 'Contribution by SKU' twice into the Values well of the matrix. For the second one, right-click and choose 'Show value as '->Percent of Row Total.   Then rename the second one 'Contribution by Channel'