Forum Discussion

hung0902's avatar
hung0902
New Member
9 years ago

How do I create a percentage column?

I have a report with Total AMount by Channel. I have a sum of Total Amount. How do I create a column that calculate percentage of total amount of each Channel by sum of Total Amount.
anupampandey's avatar
anupampandey
Helper III
9 years ago

Hi,

 

Create a measure: 

 

Percentage of Total = Total Amount by Channel / Sum(Total Amount by Channel)

 

Hope this will work or else you can share some sample data.

 

Thanks,

Anupam