示例集合分析语法运算符表达式说明sumsalesset analysis examples.pptx

SampleSetAnalysisSyntaxExamples–SetOperatorsSetExpressionDescriptionsum({$}Sales)Returnssalesforthecurrentselection,i.e.thesameassum(Sales)sum({1}Sales)Returnsthetotalsaleswithintheapplication,disregardingtheselectionbutnotthedimension.Ifusedinachartwithe.g.Productsasdimension,eachproductwillgetadifferentvalue.sum({1-$}Sales)Returnssalesforeverythingexcludedbythecurrentselection.sum({$1}Sales)Returnssalesforthepreviousselection.sum({BM01}Sales)ReturnssaleswithintheselectiondefinedbybookmarkBM01Examples-Basic:SetExpressionDescriptionsum({1Region={US}}Sales)ReturnsthesalesfortheregionUSdisregardingthecurrentselection.sum({$Region=}Sales)Returnsthesalesforthecurrentselection,butwiththeselectioninRegionremoved.sum({$Year={2000},Region={US,SE,DE,UK,FR}}Sales)Returnsthesalesforthecurrentselection,butwithnewselectionsbothinYearandinRegion.sum({$Year={“2*”}}Sales)Returnsthesalesforthecurrentselection,butwithallyearsbeginningwiththedigit2,i.e.mostlikelyyear2000andonwards,selectedinthefieldYear.sum({$Year={}}Sales)Returnsthesalesforthecurrentselection,butwithallyearsBetween1978and2004.

Examples–Usingdollar-signexpansions:SetExpressionDescriptionsum({$Year={$(#vLastYear)}}Sales)Returnsthesalesforthepreviousyearinrelationtothecurrentselection.Here,avariablevLastYearcontainingtherelevantyearisusedinadollar-signexpansion.sum({$Year={$(#=Only(Year)-1)}}Sales)ReturnsthesalesforthepreviousyearinrelationtothecurrentExamples–Advanced:SetExpressionDescriptionsum({$–1Product={“*Internal*”,“*Domestic*”}}Sales)Returnsthesalesforthecurrentselection,excludingtransactionscontainingproductswiththestring‘Internal’or‘Domestic’intheproductname.sum({$Month={=$(#=max(Month))},Year={$(#=max(Year))}}Sales)Returnsthesales