2 Replies Latest reply on Nov 7, 2018 5:42 AM by krishna.amilineni.0

    Average of count for max date

    krishna.amilineni.0

      Hi All,

       

      I am facing an issue in getting the average count for a fixed person.

      I have created a fake scenario and attached it.

      The data is as shown in the screenshot.

      My requirement is, for a fixed dealer get the avg(member count) for the latest date.

      I have used the below LOD:

      { FIXED [Provider Name], [Year], max([Month]): AVG([Member Count])}

      It is throwing the error "Cannot use aggregated expression as a dimension, because it is a measure. "

      I am struck with this since quite a bit of time.

      Any help is appreciated.

      PFA data.

       

       

      Thanks

      Krishna