Forum Discussion
Sum total per categroy
I am trying to have the total Labor hours which is a measured column within the table public_work_order_logs per each class which is in its own table public_classes.
But as you can see it is giving me the total sum for each class. How can i fix this?
Below is my schema as well and i highlighted each column from the tables that i am usuing.
2 Replies
- Greg_Deckler
Community Champion
Anonymous Well, something is either a measure or a calculated column. Looks like your Labor Hours is a calculated column. If I am reading your data model correctly the issue seems to be that your Class column (Name in public classes table?) is not related to your public works order log table and thus your Labor Hours calculation. You will need relationships defined with the directions of those relationships such that the first table filters the other. Also, it is almost certain that if Labor Hours is a calculated column you will need this to be a measure instead.
