Hi,
Let's say that I have a set of data with an index for each week day, column with some product occurrence per week day and a third column with some values. That might look like this:
WEEK DAY, PRODUCT, VALUE
1, A, 5
2, A, 2
3, A, 1
3, B, 5
4, A, 2
4, B, 1
5, A, 5
5, B, 2
6, A, 1
7, A, 5
I create a Pivot Table where Rows are broke by Product and columns by Week Day.
When I apply a filter on Product and choose B, then columns for week days 1, 2, 6 and 7 will hide since there is no data for Product B in other Week Days.
I am trying to find out if there is a way to make the columns labels fixed (but not by fixing raw data) - so even if we apply filtering for Product B, we get all 7 column for all weeks days where fields for days 1, 2, 6 and 7 are just blank or filled with 0.
Let's say that I have a set of data with an index for each week day, column with some product occurrence per week day and a third column with some values. That might look like this:
WEEK DAY, PRODUCT, VALUE
1, A, 5
2, A, 2
3, A, 1
3, B, 5
4, A, 2
4, B, 1
5, A, 5
5, B, 2
6, A, 1
7, A, 5
I create a Pivot Table where Rows are broke by Product and columns by Week Day.
When I apply a filter on Product and choose B, then columns for week days 1, 2, 6 and 7 will hide since there is no data for Product B in other Week Days.
I am trying to find out if there is a way to make the columns labels fixed (but not by fixing raw data) - so even if we apply filtering for Product B, we get all 7 column for all weeks days where fields for days 1, 2, 6 and 7 are just blank or filled with 0.
