advanced top 100 list query



I am trying to create a list of top 100 customers by spending for each
store.

I can successfully create the list of top 100 customers for all stores, but
when I try and group by store, not all stores are represented.

Is it possible?

WB


.