7 Replies Latest reply: Jul 11, 2017 8:45 AM by Burhan Göker RSS

    How to only show max value with two dimensions (date and dealer)

    Burhan Göker

      Hi! As you can see in the picture below the maximum value for ex. 2017-06-01 is 42 and it is shown in the column named "Totals orders". However I only want it do be shown once per unique date and the other rows should be deleted. Someone here that knows how to do it? Thanks.

       

      My script:


      *Main sheet*

      GDS_DATA:
      LOAD DATE
      [Branch Number],
      [SEL0004]

       

       

      *Main 2 sheet*

      LEFT JOIN (GDS_DATA)
      PreLoading:
      LOAD
             DATE,
             [Branch Number],
      MAX (SEL0004) AS [Total Orders]
      RESIDENT GDS_DATA
      Group by DATE, [Branch Number];