Forum Discussion

TBenders's avatar
TBenders
Icon for Helper II rankHelper II
10 years ago
Solved

Combining rows based on unique id, and combining information

Hi,   This is my first post on this forum, but I've been 'lurking' around for a while, learning as I go. Hopefully one of you BI-wizards can help me out with my particular case for which I couldn't...
Need Help
  • ImkeF's avatar
    ImkeF
    10 years ago

    Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
6 years ago

That's because your table is missing a unique identifier that determines the row.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Imke - perhaps you can help me with a similar situation. I am also trying to combine data like the previous users but mine would be by date and I want the sum of the numbers instead of just a count. It looks like the aggregate only gives a count? 

 

The situation is multiple locations entering data into different tables on the same date and I would like to combine those into a global sum for each attribute being tracked while having accurate monthly/quarterly numbers.