Forum Discussion
Summarizing one table in a new table
How about a New Calculated Table
From the Modelling Tab>>New Table
New Table = DISTINCT(Table1)
Im not sure if that will work because if i have 4 distinct names in the column 'Projectnaam' then it wille return those 4 values in Column A in 4 rows.
In Column B i need the unique City names that are in the Projectname
If for instance Projectname A has 10 different cities in it i need 10 rows with in Column A 10 times the same Projectname and in Column B the 10 unique citynames for that given Projectname.
It works with your sample data
Could you give me some more data and expected results to work with?
Its hard to explain but im gonna try none the less.
I now have tabled based on 'City' names and a few calculated colums such as 'total amount of adresses', 'adresses that have status x', 'adresses that have status y' etc etc.
But that is based on the city and now im missing the column for the 'Projectname'.
For example there are 1483 homes in the city of Avenhorn but it's a possibility that 1000 homes are in Project A en 483 are in Project B. I need to be able to make that difference so i need to add that column.So basically if Avenhorn is in 2 different projects i need to rows for Avenhorn telling me how many homes are in Project A en how many are in Project B.
