1 of 1 people found this helpful
Create a calculated field similar to the following:
if total(sum([Sales]))>=100000 then sum([Sales])*.10
elseif total(sum([Sales]))>=1000000 then sum([Sales])*.15 end
Place this on the view. Next, you'll have to change the way the calculation is being computed. Right click on it, select Compute Using-->Parent Company
Hope this helps!
Thank you for your help! I have a follow up question that I would love your input on.
I would like to bin my child companies based on parent company size and compare price bands for the same product. For instance, I would like to plot price paid (dimension) against something like this:
if sum([Revenue]) > 1000 then "big customer"
else "small customer"
I noticed when I created this calculated field and dragged it to the X axis, Tableau marked it as an aggregate calculation. How do I get it to aggregate based on parent company?