3 Replies Latest reply on Jan 20, 2019 2:25 AM by Mahfooj Khan

    Total of Weighted Average on a different level

    Aaron Winkel

      Hello,

       

      I'm working on a dashboard for a fantasy league that calculates point values based on the rank of the drafted team.  i.e. if someone is drafted 1st they get their weekly points * 1, if drafted second they get their weekly points * 0.8, etc.

       

      I'm attempting to show a total of the Weighted Scores by League Member however it only seems to work when I have Rank in the Column headers.  I want to show the correct weighted average by Member without needing to show the Rank.

       

       

       

      Can anyone explain what I need to do to fix this?  Using 10.5

       

      Thanks!!