Using Set Analysis to calculate Indicators

[Anonymous]

Dear colleagues,

I have a table in which I have to do extract three KPIs:

1. Number of production orders
2. Quantity of products received
3. Number of Products demanded

ID	Date_Received	Type ID	Number_Products_Received	Number_Products_Demanded
1	01/01/2017	1	30	75
1	15/01/2017	1	45	75
2	16/01/2017	1	20	40
2	24/01/2017	1	20	40
3	15/02/2017	2	10	10

• For indicator #1, I need to calculate the number of different IDs, which type is not 2;
• For indicator #2, I need to calculate the number of products received per ID (it is important to say that there can be other field that can duplicate the values above)
• For indicator #3, I need to calculate the number of products demanded per ID, which type is not 2 (please check that the field of number of products demanded replicates according to the received date - and there can be other fields which can duplicate the value as well)

Can anyone help me with this?

Thank you in advance!

[sunny_talwar]

May be these

1) Count(DISTINCT {<[Type ID] -= {2}>} ID)

2) Sum(Aggr(Sum(DISTINCT Number_Products_Received), ID, Date_Received))

3) Sum({<[Type ID] -= {2}>} Aggr(Sum({<[Type ID] -= {2}>} DISTINCT Number_Products_Demanded), ID))