Hello,

What would be the formula for this information requirement.
StoreNbrCount

A client is running an MDX query where due to filtering
using many different criteria only a subset of the open
stores are to be included.

This count will always vary by each weekly time period.
There is a dimension StoreHistory which has a row
for each timeperiod a store is open.

Time Sales StoreNbrCount

wk 1 123 10
wk 2 122 11
wk 3 124 11
wk 4 123 10

What would be the defintion of StoreNbrCount?

Thanks