Set Analysis to exclude particular column row value

[Anonymous]

Hi Friends,can any one please help on set Analysis Issue facing .My scenario is how to exclude particular row in calculations below st. table need to sum up A-D as Total in Grade Column.Below is the Expression for Item  Diff .

vItemDiff= if (count ([Final  Indicator])=0,' ',(1+if (Sum([Actual X Sales]) = 0,' ',\ Sum ([Actual R Sales])/sum([Actual X Sales])-1))/(1+ if (SUM ([WgtsX Sales])=0,' ', SUM ([Wgts R Sales])/SUM ([WgtsX Sales])-1))-1)

O/P                                

Grade	Item Diff
A	21
B	3
C	4
D	4
No Master	11
Total A-D	43

Desired Expected Output:

Grade	Item
A	21
B	3
C	4
D	4
No Master	11
Total A-D	32

[Peter_Cammaert]

Change your expression into something like:

=if (dimensionality() = 0, NEWEXPRESSIONWITHSETANALYSIS, $(vItemDiff))

This will select a different expression whenever a total is being calculated.

What will NEWEXPRESSIONWITHSETANALYSIS become? The same expression as you listed above, except that every aggregation function should contain a set spec like:

... {<Grade = {"A", "B", "C", "D"}>} ...

Best,

Peter

[Anonymous]

can you please explain in clear case.In above solution you provided not getting exactly in normal to exclude in set analysis we use-= in set

[Peter_Cammaert]

Then use a comparable set modifier that starts from the current selection:

... {<Grade -= {"No Master"}>} ...