6 Replies Latest reply on May 22, 2018 11:13 AM by sirisha.putta.0

# Calculated Field for Percent of Total

Hi all,

I am building a report with the advertising spend of competitors over time, and I want to make a calculated field for the Share of Voice of each competitor. So, for example, if the total spend was £1000, competitor A spent £500, competitor B spent £250, and competitor C spent £250, I need a field that says competitor A: 50% SoV, competitor B: 25% SoV, competitor C: 25% SoV. So it's just the individual spend of a competitor divided by the total spend that I need. Is there a way to do that?

Thanks,
Lotte

• ###### 1. Re: Calculated Field for Percent of Total

Hi There!

That would be a calculated field like:

SUM(Your Measure)/TOTAL(SUM(Your Measure))

Or you can place the dimension that has the names of the competitors on rows, measure value on text on the marks card. From the analysis tab up top go to percent of > table 2 of 2 people found this helpful
• ###### 2. Re: Calculated Field for Percent of Total

Thank you for your response. I've done the calculation like formula you said, but it seems to calculate it over the whole table. I would like it to do it per month, so each month they add up to 100%, then you can see the change over time. Now, I get really small numbers, because it calculates the number as a percent of the entire table, instead of just over the columns. Is there a way to have it grouped by month?

thanks,
Lotte

• ###### 3. Re: Calculated Field for Percent of Total

You will have to make sure compute using settings are set correctly. If you have a view somewhat like this, it should be set to pane(down). In most cases, it always helps volunteers help you if you faster if you attach a sample workbook: 1 of 1 people found this helpful
• ###### 4. Re: Calculated Field for Percent of Total

Ah great! that works. One last question, if I now make a filter to only include the biggest competitors, it excludes the spend of the small ones entirely, because it then uses the total of only the ones I've selected. Is there a way around that? So that even if I only select competitor A and B, it still calculates the SoV based on A, B and C?

Thanks,

Lotte

• ###### 5. Re: Calculated Field for Percent of Total

hey guys, great write up! I'm using a Top N filter to show, let's say, the Top 10 Customers. I'm then displaying four measures next to each customer like: sales, revenue, etc...

I would like to keep the Top N filter on and then show that customers % of total business for each measure company wide. I don't think that this calculation is computing correctly with that filter in play.

Any suggestions?

Thanks!

• ###### 6. Re: Calculated Field for Percent of Total

I tried using the calculation (avg(class A/total classes)) by editing the field which gave the average .But, how can I show the actual numbers using tooltip?

Any thoughts?

Thanks.

Sirisha