1 Reply Latest reply on Oct 8, 2018 8:13 PM by swaroop.gantela

    Calculating a dynamic weighted average

    Barnwell W Hughes

      Hello,

      Below I have attached an example of what my data set looks looks like. The problem I am having is that for each period,(0-5), I would like to calculate a weighted average for the values based off the OrigAVG. The issue I am having in tableau is users will filter out options by other fields such as Cust or Fico and I need it to recalculate the weights based off what filter is applied. Does anybody know of a formula that could weight the replines at each period when different fields are being filtered each time? Thanks.