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.
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.
