Forum Discussion

Frequent Visitor

2 years ago

Measure for a table

Hi all, I need some help creating a table in a report. I have a table named ‘NP’ with several columns, one of them is ‘Register’ and another one named ‘ID’, that represents a company. In NP t...

Frequent Visitor

2 years ago

Hi Anonymous ,

Yes, of course. Please see below:

The relationship:

PPL NP

Register *:1 Register

NP table sample data:

Register	Serial	EGP	PPLEndDate	AP	CompanyID
7	671	1979	30/06/2023	16,5	172349573016
12	8612	1979	31/10/2024	16,5	47685043327
24	6518	1982	02/08/2021	16,5	243672296763
37	912	1980	30/09/2024	17,1	379565974126
39	9141	1980	31/08/2022	16,5	964123160093
42	3711	1979	13/03/2024	24	243672296763
4288	9741	1984	01/08/2022	16,5	243672296763
14065	7610	1993	01/08/2022	16,5	243672296763
14397	9315	1965	30/09/2024	16,5	379565974126
95650	6472	1991	30/09/2024	16,5	379565974126
111578	4972	1979	31/07/2024	25,5	243672296763
112325	9474	1979	02/09/2024	25,5	964123160093
129471	6578	1995	01/07/2024	24	80084620022
130546	3412	1995	30/09/2024	18	349059847
130745	2313	1995	30/09/2024	18	349059847
139348	7147	1998	02/09/2024	18	964123160093
141008	4812	1997	30/09/2024	18	349059847
141765	9711	2001	02/09/2024	25,5	964123160093
161397	7893	2008	01/07/2024	21	80084620022
163973	4821	2011	01/07/2024	24	80084620022
168471	2674	2012	01/07/2024	24	80084620022
170647	1571	2013	30/09/2024	24,9	349059847
172496	5942	2013	01/07/2024	24	80084620022
176429	5596	2015	01/07/2024	21	80084620022
185671	6924	2017	30/09/2024	16,5	349059847
187846	8674	2017	30/09/2024	24	349059847
198347	5046	2022	16/03/2024	25,5	349059847
200604	1786	2023	10/03/2024	24,9	349059847
200876	7315	2023	16/03/2024	24,9	349059847
202873	5631	2023	10/03/2024	24	349059847
206712	8924	2023	16/03/2024	24	349059847

PPL sample data will be in another comment since it's too long and I can't post it on the same message.

With the sample data, and assuming the user selects 31/12/2023 as the date, the table I'd like to add to the report would look like this:

Registry	Companies
1	1
2	1
3	2
4	0
5	0
6	1
7	0
8	0
9	0
10	0
>10	1
Total	6

Thank you and best regards,

Veri.