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