Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I only want to display products sold in one specific sales channel in a table.
The income for product 4 and 5 is filtered out by sales channel in a set expression. The problem is that production cost does not have a sales channel dimension.
Is it possible to only display product 1, 2 and 3 when the right products are filtered out by Income?
Product | Department | Income | Production cost |
1 | 100 | 100 | 50 |
2 | 120 | 75 | 25 |
3 | 100 | 90 | 40 |
4 | 100 | 30 | |
5 | 120 | 70 |
I have over 40 000 products.
Thanks!
Thanks!
It worked with: If(Aggr(Sum(Income)<>0,Product),Product)