Hello,
I am having trouble with a pivot feature and I have Excel 2007. My raw data for example has different entries for a same date, When building the Pivot, I need to check the Min of each date. So when I change the Value field setting to Min, the Subtotal will also be the Min (I need the Sum of all the Min). When I try a calculated formula field in the Pivot it will not return the absolute minimum data for each date.
Please help!
Andres Benavides
I am having trouble with a pivot feature and I have Excel 2007. My raw data for example has different entries for a same date, When building the Pivot, I need to check the Min of each date. So when I change the Value field setting to Min, the Subtotal will also be the Min (I need the Sum of all the Min). When I try a calculated formula field in the Pivot it will not return the absolute minimum data for each date.
Please help!
Andres Benavides