0 Replies Latest reply on Oct 4, 2018 5:35 PM by Joseph thomas

    Dynamic Average Calculation based on Filters

    Joseph thomas

      Experts, Let me know if you can help me with this scenario. My data is as below ( one ID, Few dimension and Measures) 

      IDDim1Dim2Val1
      1North201810
      2South201820
      1North201730
      2South201740
      3North201820

       

      Dim2Average
      201816.66667
      201735

       

      overall Average25

       

      Dim1Average
      North20
      South30

       

      What I need is as below? When the user selects specific ID and a Dimension combination, what is the best way to dynamically create the "Compare Avg" Value based on the dynamic filter?

         

      IDDimensionavg(val1)Compare AVG
      1No Dimension20overall Average
      1201810Full 2018  Average
      1201730Full 2017 Average
      1North,201810Full North, 2018 Average

      Thanks for the help.