No Data Available /content/folder[@name='Samples']/folder[@name='Models']/package[@name='GO sales (analysis)']/model[@name='model'][Sales (analysis)].[Sales].[Revenue]Revenue[Sales (analysis)].[Sales]Sales[Sales (analysis)].[Sales].[Quantity]Quantity[Sales (analysis)].[Sales]Sales# promptmany('Retailers','mun','[Sales (analysis)].[Retailers].[Retailers].[Region]','set(','',')') #total(currentMeasure within set [Retailers])total(currentMeasure within set filter([Retailers], count(member(1) within set intersect([Retailers],set( ancestor(currentMember(hierarchy([Retailers])),1) , ancestor(currentMember(hierarchy([Retailers])),2) , ancestor(currentMember(hierarchy([Retailers])),3) , ancestor(currentMember(hierarchy([Retailers])),4) , ancestor(currentMember(hierarchy([Retailers])),5) , ancestor(currentMember(hierarchy([Retailers])),6) ) )) = 0) )total(currentMeasure within set filter([Retailers],count(member(1) within set intersect( descendants(currentMember(hierarchy([Retailers])),0,after), [Retailers] ))=0))[Sales (analysis)].[Retailers].[Retailers] in (?Region?)rootMembers([Sales (analysis)].[Retailers].[Retailers])summing leaf