I need to find out about each item, how many stores have sold it! query below gives the total no. of stores count where all the items have been sold! what is wrong?
pl. help!
with
set temp as {nonemptycrossjoin({[Item].[Item Name].currentmember},{[Location].[Location Name].children},{[Measures].[Sales Qty]},2)}
member measures.SetCount as temp.count
select
{measures.SetCount} on columns, {[Item].[Item Name].&[0104205090]:[Item].[Item Name].&[0104259903]} on rows
from sales