0

related fields in Pivot Table

I have a table which contains a date with a price fields.  The day is broekn into Day field, Month field and Year Field.  The Pivot Table view is then created using Year for left axis and Month for horizontal axis.  This works and the content should be the minimum price for the month of that year. This works but the other field I need is the date on which that minimum occurs.  I cannot tyhink how to do this in the pivot table. Ideas please.  Ideally I then wanted to conditional style it but this doesnt seem possible .

Reply

null