topic Filter on one of two measures in App Development

Filter on one of two measures

Hauglaen — Tue, 20 Aug 2019 12:37:49 GMT

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!

Re: Filter on one of two measures

arvind_patil — Tue, 20 Aug 2019 12:42:22 GMT

Hi,
Please try calculated dimesnion.

if(Sum(income)>0,Product) as Product

Re: Filter on one of two measures

Hauglaen — Tue, 20 Aug 2019 13:01:51 GMT

Thanks!

It worked with: If(Aggr(Sum(Income)<>0,Product),Product)