Hi everyone,
I am wondering, I have the following expression:
sum({<ORDER_TYPE = {'ORDER'}, DOCUMENT = {'BILL'}>} sales)
Now we set filters to a single brand and a single salesperson to generate reports for them. Problem is, in the expression above I want all those setting to be for the correct filters, except I want this expression to show all salespersons. I can't deselect the salesperson, since we have more reports.
I was thinking in the order of: sum({<ORDER_TYPE = {'ORDER'}, DOCUMENT = {'BILL'}, SALESPERSON = {1} >} sales)
But this obviously doesn't work. If we use sum({<ORDER_TYPE = {'ORDER'}, DOCUMENT = {'BILL'}, SALESPERSON = {*} >} sales) I still find problems, since it shows only the articles sold for the selected salesperson, not all in total.
Who can help?
