Forum Discussion
Calculated Column based on Totals from Values
I need to create columns showing total count of work locations by department. I would like to have this output table below: Original Table Department Work Location HR Onsite HR Onsite ...
Hi Jadegirlify ,
Do you need this to be a calculated column? You could try using a Matrix visual and putting the DepartmentWorkLocation field in the columns field.
Hi, it can be a matrix, i tried to do a matrix but the columns still weren't coming up right.
djurecic It didn't work with a Matrix, I was getting 1 in each row as on the Total Department column as the values for Onsite, Virtual and Total were also not accurate
