Unique values need to show

[Gowtham174]

Hi All,

Can you please help me to show this in 3 different table.

I.e 

Table 1 only top10

Table 2 only top20 which is not there in top10

table 3 only top30 which is not there in top10 and top20

[Channa]

year

if( not isnull(top10),year)

name

if( not isnull(top10),name)

top10

not isnull(topo10)

[tresesco]

Assuming  Top10, Top20, Top30  are fields as well as values to respective fields. Try like:

Table 1:  Sum({<Top10={'Top10'}>}Sales)

Table 2:  Sum({<Top10-={'Top10'},Top20={'Top20'}>}Sales)

Table 3:  Sum({<Top10-={'Top10'},Top20-={'Top20'}, Top30={'Top30'}>}Sales)

If this doen't help, try to share your sample app.

[Gowtham174]

Tresesco

table 2 and table 3 values is showing 0

attached app for reference

[Channa]

i did for table 2 try did same for table 3

it is working

[Channa · Accepted solution]

for table 3

for year below

=IF(Top30='Top30' and Top10<>'Top10' and Top20<>'Top20',Year)

measure

=if(Top10<>'Top10' and  Top20 <> 'Top20',Sum({<Top30={'Top30'}>}Sales))

[tresesco · Accepted solution]

Please try the below expressions:

Sum({<Sales =e({<Top10={'Top10'}>})>}Sales)
Sum({<Sales =e({<Top10={'Top10'}>}),Sales =e({<Top20={'Top20'}>}),Top30={'Top30'}>}Sales)