can you please attach sample workbook
1 of 1 people found this helpful
Are you trying to filter the view without filtering out underlying data?
If so, this article (with video) may be what you're looking for:
The secret-to-the-sauce when using your quick table calcs is to keep your primary date out of the Filter card; doing so will remove the data from the calculation (which I don't think you want to do).
Instead, create a calculation that controls what is viewed. In the video you can see they used this:
Date Lookup Filter
It took a little testing on my part, but I was able to get this to display just the years I wanted to see without affecting their % change calcs.
Hope this helps!
Thank you so much! Yes, this worked perfectly!