Forum Discussion
How to aggregate multiple records in a table?
Hi guys, I need your help. I've run out of attempts. It seems so simple, but I couldn't do it. 1) I just need to sum/avg/max up all the values of a single record. For instance, I want 16 n_...
Thanks for your reply Anonymous, but it didn't work.
Please, note I'm working with relationships (2 tables in this scenario).
Also the values come from a fact table where the records values are 0 or 1, so in the example above, the value of 6 are 6 rows with 1s values summed up. That's why I'm having trouble with MAX, because it usually shows 1.
Any other tip?