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?
I think you can accomplish your goal using a start and end date parameters on a calculated field rather than filtering the date. Filtering by date filters out the previous month from the data which so there is nothing to lookup.