Bar Chart Percentages

[EvanBarrick]

I have a bar chart with a dimension of 'Category'

the Measure is 'Conversions'

I am attempting to create a horizontal bar chart, on which i want each 'Category' to display it's percentage of 'Conversions' 

For example, there a total of 400 'Conversions' and the 'Category' direct represents 100 'Conversions' so I would want that to display as 25%

[skamath1 · Accepted solution]

Try   Sum(Conversion)/Sum(Total Conversion) . Format the number as percentage.

[lblumenfeld]

See the attached example. I used

Sum(Conversions) / Sum(total Conversions)

and formatted the number as a percentage  #,##0.0%

[EvanBarrick]

When I use this, the percentages do not end in the output I would expect.

Here is my actual data:

Category                   Conversion

Web                             307

Referral                      45

ESAB1                         16

ESAB2                         19

RG1                               1

RG2                               0

RG3                               0

TW                                  1

Direct                           0

So the total is 389. The percentage for the first category should be 79% but when I am getting 30%

[skamath1]

Use the Sum function. It works 

[lblumenfeld]

Are you sure you're using the formula I used? That should work, unless your chart has additional dimensions. Is it just Category as the dimension?

[EvanBarrick]

Problem was with my data, this functions. 

My data file has a totals row that I was unaware of