I have a pivot table that I'm using for planned shipments show the 'planned source' and 'planned destination' and it shows for each product, the top 3 cheapest sources.
See the attachment. When I have it collapsed to the 'calendar_week' level, I should not be seeing the 'Total' values for the cheapest sources because it does not make any sense. The cheapest sources are by products for a specific destination so the only way that totals should be shown is if i expand it all the way to the destination column...
Is there anyway that this could be done? any tips or ideas will be really appreciated!
