3 Replies Latest reply on Oct 14, 2015 12:38 PM by #Mayur

# How to calculate percentage of monthly sales

HI,

I have a month sales column and i have another column which calculates (month sales/(total monthly sales))*100.

How to calculate this Percentage of sales.

Regards,

Chandrakanth.

• ###### 1. Re: How to calculate percentage of monthly sales

You can use the AGGREGATE function to get the TOTAL monthly sales in the year:

Something like: AGGREGATE("monthly sales measure" AT "Time"."Time Hierarchy"."Year")

Then calculate your final formula like:

"monthly sales measure"/ AGGREGATE("monthly sales measure" AT "Time"."Time Hierarchy"."Year")*100

• ###### 2. Re: How to calculate percentage of monthly sales

Or, if you display the year itself in the data (many months) and next to each you want to display the % of the total yearly sales you do it with 1 click in the pivot view (display as % of ...).

But 872208 option is the cleanest one (assuming your BMM is done correctly and you have hierarchies for all your dimensions.