HI,
I have a pivot table that has rows of a list of products, each column is a week. e.g ,1,2,3...50,51,52. I am trying to have the 2 last columns be the min value within the 52 weeks and the max value in the 52 weeks for each product.
This would ignore blank or zero columns.
I have tried using Calculated fields but i cant get it to work. If i use Min and Max formula it does not follow when I change the criteria on the Pivot
Any help would be great
See below example
I have a pivot table that has rows of a list of products, each column is a week. e.g ,1,2,3...50,51,52. I am trying to have the 2 last columns be the min value within the 52 weeks and the max value in the 52 weeks for each product.
This would ignore blank or zero columns.
I have tried using Calculated fields but i cant get it to work. If i use Min and Max formula it does not follow when I change the criteria on the Pivot
Any help would be great
See below example
