4 Replies Latest reply on Oct 3, 2018 9:54 AM by marc de Latour

    Finding average of aggregated fields, while hiding LOD- Fixed - CountD

    marc de Latour

           good afternoon,

       

      I am having some issues.

       

      I have included the sample store data for reference.  keep in mind its derivative on my issue so you may find your self wondering why he is doing this, it doesn't make much sense with sample store data, but for my issue it does.

      1) i'd like to divide these two numbers,  fixed sum of sales by state and date. and countD of cities. for an average sales for region by city.

       

      2) I would also like to get a similar number for the average of the "difference from" for state by city ...any help would be appreciated