Using a Dynamic Date Filter

I am trying to create an item list by Location with sales figures for the past 6 months and the past 12 months. How would I set up a filter to create a range from date of report run back 6 or 12 months? And what would be the best way to use them? I would be using the Item Ledger Entry table…I'm assuming that I need to use the sum feature in the NL function…but not sure how to do the date range. Here's the NL function so far…

=NL("Sum","Item Ledger Entry","Quantity","Location Code",Options!$D$5,"Entry Type","Sale","Item No.","@@"&$D6)



Please sign in to leave a comment.