How do i find % in a bar chart using set expressions?

[amrutha_sathish]

So i have a bar chart showing trend of three months, containing 3 marketing channels - Search , Social , Display.

I need to find the % of each one of them - for eg.: Search% =  Search /Search+Social+Display.

What would be the set analysis expression?

[daturpin]

So your dimension is months, and you have three measures: Search%, Social%, Display%?

All you should have to do is, in the expression editor for each measure, use:

=Sum([Search])/Sum([Search]+[Social]+[Display]) * 100 & '%'

[cristianj23a]

Hello, use this code:

Sum(Search) / (Sum(Search) + Sum(Social) + Sum(Display)) 

In the same graph you format the calculation:

Regarts.

[amrutha_sathish]

no no, so i have a dimension named 'marketing channel'

[anat]

assuming you have 'marketing channel' as a dim

and use below measure to show percent for dim values

num(sum(sales)/sum(total sales),'0.00%')