Weighted Average Set Analysis With Aggr in a Text Box
I need to show the weighted average copy duration in a text box basis share of spend a brand has basis its ad durations. The sample table is attached along is self explanatory which contains the steps to reach to a desired number in a text box. Please help me out how can i get this done.
I have reached to the point where i am getting the product of 'share of spend' and duration in a table. Whereas, this has to be done in a text object. Below is the set analysis i have reached up till now.