2 Replies Latest reply on Oct 2, 2018 1:44 AM by Kevin Esther

    Highlight the max dimension on cumulative line chart

    Kevin Esther

      Hi,

       

      I have attached sample workbook showing the workings and calculations that I have so far creating a cumulative line chart.

       

      The goal is to highlight the staff ID with the highest running total to date.

       

      The data set am working with got lot more staff and want to highlight only the person at the top and grey out the rest.

       

      I am close but currently only highlight all the end points.

       

      thanks

      Kev

        • 1. Re: Highlight the max dimension on cumulative line chart
          Jim Dehner

          Hi Kevin

          Is this what you expected

           

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: Highlight the max dimension on cumulative line chart
            Kevin Esther

            Thanks Jim, am closer to what am after for some reason with the actually data am getting wee bit different results.

             

            I can highlight the end of the line no problems just want to highlight the top 1 and grey the rest as my view in the actually data got hundreds of lines.

             

            Compute using the staff id getting me closer.

             

            Guess what am doing is to say

            • Find highest running total end point so the last index
            • Then I want to highlight all the index for that line

             

            I tried to use LOD however that doesn't work as got table calculations unless and messing something.

             

            Thanks Kev