Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Group by

Hello, I have 5 Columns (ClasssNumber, Classtart, PersonInClass,Name and Person Number) and there are more Names and PersonNumbers then ClassNumbers and Classtarts(there can be multipl lessons I already merged them), but the problem is that Name and PersonNumber are in an other Table. So when I want to expand the Table, because i need the name, the ClassNumber (Sum from all ClassNumbers ) is wrong, because there are more Names then ClassNumbers.

Can someone help me, if you need more info pls tell me

(KursNr. = ClassNumbers, Kursstart = Classstarts, PersonenInKurs = PersonInClaass)

In the Tabel:

 

4 Replies

  • Hi,
    Information is not clear.
    Can you pls explain. What do you want to do in grouping ?

    • Anonymous's avatar
      Anonymous
      Not applicable

      I want to add Name and PersonNumber, but the Problem is, that there are more Names and PersonNUmber then Classnames, Classnumber and classstart. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      That is not possible, I am sry