Percentage of grand total

[Anonymous]

below is the following data i have i am looking to do a percentage of grand total based on the below data. So for number of days = 1 and the count being 374  what is this as of a percentage of the grand total. After i will then need to make this cummulative over numver of days

[ZunzunUOC]

Hello @Anonymous , I have no clear what you need.

Is this your goal?

day            count     %

1                30          30%

2                10          10%

3                45          45%

4                15          15%

[Anonymous]

@ZunzunUOC yes basically but then i need to make it cumulative afterwards

[ZunzunUOC · Accepted solution]

Ok, here you are, I think this is you need:

Create 2 calculated columns:

perc = ('PERCENT'[COUNT]/SUM('PERCENT'[COUNT]))*100

CumPerc = CALCULATE(SUM('PERCENT'[perc]);FILTER('PERCENT';'PERCENT'[DAY]<=EARLIER('PERCENT'[DAY])))

Results:

Best Regards,
Miguel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@ZunzunUOC  thanky ou for your reply have tried the 1st column but am getting % over 100 which obviously i shouldnt any ideas screen shot attached

[ZunzunUOC]

Care, you need to use brackets:

[Anonymous]

@ZunzunUOC Still the same issue

[ZunzunUOC]

Ok, delete 100 on your code please. If you use % format, not need to multiply per 100

[Anonymous]

@ZunzunUOC  Sorry still not working i know the total is 6700 so the attached numbers are deff wrong that i am getting when using your formula

[ZunzunUOC]

This is a rounded number, you can add decimals and solve.