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?
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?
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.
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?