Forum Discussion
Summarizing one table in a new table
Goodday,
How can i summarize 1 table into a new table if i want the following result
Mainproject City
A A
A A
A B
A B
B A
B C
A C
B A
A A
C A
C D
the desired outcome should be this (without the colours ofc but with the summarization and grouping)
Mainproject City
A A
A B
A C
B A
B C
C A
C D
I dont want to work with additional colums (if that is possible)
10 Replies
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?
