In my pivot table there is one column labeled ‘Week’ and two values: ‘Sales and ‘KPI’. I would like to display ‘Sales’ for all weeks but show the ‘KPI’ only for the last week. Is there a way to achieve this without resorting to hiding columns?
In my pivot table there is one column labeled ‘Week’ and two values: ‘Sales and ‘KPI’. I would like to display ‘Sales’ for all weeks but show the ‘KPI’ only for the last week. Is there a way to achieve this without resorting to hiding columns?