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




      Example 2

      January     February    

      23               45               


      I would only want to display




      Thank you.