Hi Guys,
We have recently deployed Data Sharer into dashboard for quite obvious reason performance.
we know that Excel layer never gets blank and it gets overwritten anytime your dashboard is refreshed or you make new selections, reason why performance is good.
i have a statement which looks for particular cell ( if that cell is blank then make the 1st_row of the table default selected ) BUT …
it works for the first time we preview our file as all excel layer is blank, then suppose you select 5th_row from the table and try refresh the dashboard, the 5th_row is still selected and our users want it to go back to 1_row as default, and i dont know the work around need to made, as my excel layer cell is not getting clear. thanks to data sharer 
Foreg, IF( cellA= " " , Row1, cellA)
Solution:- Create a counter, not sure how to do that. please guide me the steps, highly appreciated OR anything other work around you may think off?
Please advise experts, you response will be highly appreciated.
mohdfahad (BOB member since 2012-08-09)