Top 10 stores for each state

[Smiddy]

Hello folks;

Completely new to SPLUNK.

I am trying to get a table of the 10 stores for each State for the current week (as Time) but have no clue how to write it.

I would like to see average Sales for each of those 10 stores, for each State, sorted -Avg_Sales

index = Store_Index...

Fields I guess would be State, Store, Time, Avg_Sales

I would appreciate any ideas you may have.

Thanks so much for your time.

Smiddy