Forum Discussion

rhborders's avatar
rhborders
Helper I
8 years ago
Solved

Columns not aligning unless aggregated

I am trying to put a column in my table that has a 1:1 relationship between its query and the query that houses the other columns in my table. Whenever I put the column in it does a complete table jo...
Need Help
  • rhborders's avatar
    rhborders
    8 years ago

    My desired output was to have the CustProdRep column and the Expected revenue column to be populated in both columns of row. The only way I was able to do this was by aggregating one of the columns by appling a function such as sum or count. I ended up resolving this issue by writing a SQL statement that did what I wanted so nothing had to be done in BI. 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Is the example that you are showing where it "aligns" or does not align? I'm not completely sure I understand what you mean by that.

 

rhborders's avatar
rhborders
Helper I
8 years ago

The image on the left shows that it aligns when I do a sum on the column. The right image is when there is no aggregate function and they do not align. I do not want to have to do an aggregated function on the column so that I dont not have the extra result row.