Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In a straight table, i have below dimension and expression. I dont want to show all the salesperson by their sales in the table. But only specific salespersons out of 100s.
Dimension--> salesperson
Expression-->sum(sales)
So, how can i show only specific dimension values in the straight table with its corresponding expression result.
Regards,
Suraj
Use an expression like this: sum({<salesperson={'Tom','Dick','Harry'}>}sales). The result is that the sum of sales is only shown for the salespersons Tom, Dick and Harry.
Use an expression like this: sum({<salesperson={'Tom','Dick','Harry'}>}sales). The result is that the sum of sales is only shown for the salespersons Tom, Dick and Harry.
What kind of specific values would you like to show?
Use a Calculated Dimension instead of salesperson dimension.
ex.
if(salesperson<>'XXX',salesperson)
and check suppress when value is null.
This worked perfectly for me, thanks.