Expression to identify imperatively a value

[Phara]

Hello everyone,

I'm working on production mode, I don't have the acces to be on dev mode in my corporation.

I have a table that has a column for the suppliers and a column for the service charge key. In the service charge key, I have those variables: 52-Location, 54-contract and 60-financial contribution.

I want to identify imperatively the suppliers that we spent in this key : ' 60-financial contribution'. Also I want to see all the service charges that we spent for those suppliers. 

Basically, I want to exclude all the suppliers that we didn't spend any financial contribution, I just want to see the ones that we did spend financial contribution + all the different charges.

I think it's like a group by in SQL but I'm not sure. As I said, I'm only in prod mode. What should I do?

Here is an example : 

Supplier name	Service charge key	Amount
Supplier A	52-Location	1000 $
Supplier B	54-contract	4000 $
Supplier C	60-financial	5000 $
Supplier D	54-contract	7000 $
Supplier C	54-contract	800 $
Supplier A	60-financial	9000 $

Supplier A and C has to be filtred only.

Thank you so much!

[Clement15]

Hello,

not having your data I can hardly help you but a set analysis could help you.

sum({<ID={("=sum(Valeur)>0 »)}>}Valeur)

For example here, only IDs that have a sum(Value)>0 will be filtered in the set analysis

sum({<ID={("=sum({<ID={'ID1'}>}Value)>0")}>}Value)

For example here, only IDs that are equal to 1 and have a sum(Value)>0 will be filtered in the set analysis

[Phara]

Hello, 

Here is an example, I want an expression that will identify only Supplier A and C which are respecting the following criterias :

1. They are using imperatively the Service charge key is ' 60-financial'

2. They have others Service charge key

The suppliers B and D do not respect the first criteria, so they have to be ignored.

Supplier name	Service charge key	Amount
Supplier A	52-Location	1000 $
Supplier B	54-contract	4000 $
Supplier C	60-financial	5000 $
Supplier D	54-contract	7000 $
Supplier C	54-contract	800 $
Supplier A	60-financial	9000 $

[Clement15]

Hello,

This should work, the first two columns are dimensions and here is the measurement:

sum({<[Supplier name]={"=count({<[Service charge key]={'60-financial'}>}[Service charge key])>0"}>}Amount)