0 Replies Latest reply on Nov 11, 2018 11:19 AM by A J

    Aggregated and non aggreated on same sheet in diff columns

    A J

      Hi,

       

      I have an avg of a measure, successfully filtering as well on the filter in sheet1. I need to show this 'avg of a measure' another sheet (sheet 2's column along with sheet 2 rest of the columns) on sheet 2, data shown against 'key' and on monthly basis. I need the aggregated value from sheet1 of avg of measure to be shown on sheet2 with non aggregated values based on months in columns. ig 1 and img2 are fro refe.

       

      img1: sheet1 with perfect aggregated data shown and filtering as well on a monthly range .

      avg.png

       

      img2 : sheet2

      rank2.png

       

      I need the aggregated value of say 'privacy screen' from the sheet1 on this sheet, not to be cut off on months. I know rest of the data on sheet2 is based on months in columns but I need a solution for my particular requirement.

       

      Thanks & appreciated