Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
Please try the below expressions:
Sum({<Sales =e({<Top10={'Top10'}>})>}Sales) Sum({<Sales =e({<Top10={'Top10'}>}),Sales =e({<Top20={'Top20'}>}),Top30={'Top30'}>}Sales)
year
if( not isnull(top10),year)
name
if( not isnull(top10),name)
top10
not isnull(topo10)
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.
Tresesco
table 2 and table 3 values is showing 0
attached app for reference
i did for table 2 try did same for table 3
it is working
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))
Please try the below expressions:
Sum({<Sales =e({<Top10={'Top10'}>})>}Sales) Sum({<Sales =e({<Top10={'Top10'}>}),Sales =e({<Top20={'Top20'}>}),Top30={'Top30'}>}Sales)