Hi,

I have a created a dashboard, without using any macros. All the
dynamism in the dash-board is done using formulae. I have two
drop-downs, which are cascaded, and which control the display of the
data in the dashboards.

The issue here is : I need to re-set or "clear" the data in the second
drop down, whenever the data in the first drop -down is changed. I did
manage to rummage through some of the older posts in the group, but
most of them employ macros, which i dont want to employ here.
Can this be done using formulae?

Thanks in Advance,
Sagar