3 Replies Latest reply on Aug 25, 2018 1:43 AM by Dilyana Suleymanova

    Max per Segment/Superstore

    Dilyana Suleymanova

      hello there,

      I have follow chart

       

      Please ignore the double axis for now!

      On the line chart, you see the sales per day per segment (where the segment is on the color)

       

      I want to show a point in the line chart, which shows the max for each segment, e.i the point by the segment: Home Office in March 2015 with the sales of $28,107. (So each segment should have only one dot! )

       

      This is my calculated field for this idea:

      max({ FIXED [Segment], DATETRUNC('day', [Order Date]): SUM([Sales])})

       

      However, with this calculated field, I show all points (see the dot chart)

       

      how can I fix this?

       

      Thanks

      DB