showing max (date) sales in pivot table by default and sales by selecting the year and month objects

[venkat1]

Hi 

i need a help from you regarding a scenario.

i am having year and month list boxes and pivot table with sales of gold and diamond by branch wises,

my requirement is to show by default max(date) sales ,where date fields are different for the gold and diamond,eg. g.vou_date,d.vou_date, now if i select the year and month list box then sales should come accordingly.

i tried with open sheet triggers of two field events with d.vou_date and g.vou_date but it was not working. 

[sunny_talwar]

Would you be able to share a sample where you have tried out and it wasn't working? Also, please specify what didn't work and what were you hoping it would do?