Forum Discussion

RvdHeijden's avatar
RvdHeijden
Post Prodigy
8 years ago
Solved

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          ...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

RvdHeijden

 

Please send me your Excel File.

 

I think Distinct(TableName) should do the job. Because it looks at distinct row...not a particular column

 

 

 

 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi RvdHeijden

 

Please try this calculated table based on the file you sent

 

Table =
VAR mytable =
    SELECTCOLUMNS ( Blad1, "Hoofdproject", [Hoofdproject], "plaats", [plaats] )
RETURN
    DISTINCT ( mytable )