1 Reply Latest reply on Mar 31, 2016 5:01 PM by Ivan Young

    Filtering by months without affecting change by month

    Ryan Brownlee

      Hi all,

       

      Sorry if this has been covered but I have been searching the internet all day for help and nothing seems to be working.

       

      I have a calculated field that determines market share.

       

                sum([Sales])/total(sum([Sales]))

       

      From there I have an additional calculated field that determines the difference in market share from month to month.

       

                [marketshare] - LOOKUP([marketshare], -1)

       

      I want to be able to view specific months but when I filter my results they come back as zero since the previous month has been filtered out.

       

      I've tried using lookup(min(([Date])),0), index(x), and other calculated fields as filters but nothing is working. 

       

      Can anyone help me or point me in the right direction?

       

      Thanks!