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.




      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?