Hi!
I'm creating a tracker for some new products we're launching. As they're launching at different times, some of the products will have sales of zero in the weeks before launch.
Is there a way of getting excel pivot tables to not display the weeks with zero sales?
For example, Product A launches on the 1st Jan, and Product B launches on 1st Feb. When I select Product B from the drop down at the top, is there a way to get it to start the dates at the 1st February and not display the zeros that will be in for January?
Many thanks!
Bookmarks