Hello,
I have a question about counting of unique datasets and displaying the last entry by date.
I have two tables (Customer and Data) with data.
Example:
Customer:
%ID, Name, AREA, Criteria
1, ABC, 01, B
2, BCD, 01, A
3, CDE, 02,
4, DEF, 01, A
5, EFG, 02, B
6, FGH, 01, B
7, GHI, 01,
8, HIJ, 02, A
DATA:
ID_Data,%ID, DATE, value1, value2
1, 1, 25.11.2016, yes, no
2, 2, 30.10.2016, no, yes
3, 2, 02.11.2016, yes, yes
4, 3, 02.08.2016, , no
5, 3, 08.08.2016, yes,
6, 4, 30.10.2016, yes, no
7, 5, 09.11.2016, ,
8, 6, 01.07.2016, yes, no
9, 7, 12.08.2016, , yes
10, 8, 31.08.2016, yes,
11, 5, 16.11.2016, no, yes
12, 3, 06.09.2016, yes, yes
My questions are,
1.) How can I count the unique datasets per AERA and Customer?
The problem is here, that there are more than one datasets per Customer in my data table.
If I count by "ID_Data" I get the distinct datasets from the data table but not the unique per customer.
2.) How can I display the last entry from the data table per Customer?
Unfortunately I have no idea how to solve this?
Please have a look on my attached example.
Many thanks in advance and best regards,
Claus
Nachricht geändert durch Claus Klimmer:
changed attachment due to small errors
