2 Replies Latest reply on Jun 27, 2012 5:57 AM by nora.benian

    show maximum month in a data set

      Hi, if I have a data set which shows values by month.  Depending on the chosen filter the number of months that are displayed are varied, but I always want to show the last month of the year that has data and hide all the other months.  How do I do this?

       

      Example 1

      January     February     March     April

      23               45               22          3

       

      I would only want to display

      April

      3

       

      Example 2

      January     February    

      23               45               

       

      I would only want to display

      February

      45

       

      Thank you.

       

      Sarah