Avoid summarizing on columns in query

[vaerge]

In my query (query level, not at report level), it automatically summarizes some columns. Below is an example, where the last two columns should not be summarized, because then I can't make the appropriate relations with other tables. 

How do I avoid this summarization at query level?

 

[Anonymous]

Hey @vaerge

Edit: This original post was wrong.

[vaerge]

Hi @Anonymous

Thanks - but if that is the case, then why doesn't the first column have a sigma symbol as well, since it is same type as the last two; a number. Here is a different view of that same table, where you can see the data type of the first column...which has no sigma symbol in the other view. 

[Anonymous · Accepted solution]

@vaerge Sorry I misled you. You taught me something. The sigma means it has a default summarization set for that field. If you don't want this, go to the Modeling tab and change Default Summarization from "Sum" to "Don't Summarize."

-Parker

[vaerge]

@Anonymous got it, thank you!