Weighted Average/Distribute One Column By Another

[carlcimino]

Hello, I am trying to get the Target column to show up like the Target by Distribution Column.  How can I go about doing that?  Any help would be much appreciated.

Thanks,

Carl

[vinieme12]

Can you also clarify how did you get the values  17, 33 , 50??

[carlcimino]

Column D * the value at the bottom of column C.

[vinieme12 · Accepted solution]

Just add TOTAL keyword to the expression for column C

Example

Sum(TOTAL {<YEAR .........>} PLANWP) * PremiumDistribution

[carlcimino]

Thank you it worked!  Much appreciated!