Forum Discussion

Junkay's avatar
Junkay
Regular Visitor
2 years ago
Solved

How to ccalculate total

Hi,   Thank you for all the support.   I also need a function that will create a column named "Total after the column named "Manager" and add the total for all the categories of employees:   ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Junkay 

     

    Ahmedx Good share!

     

    You can't find column total because you're not using Matrix Visual.

     

    And you can try to use Table Visual to create a calculated column or measure:

     

    Create a calculated, add up the columns you need.

     

    total = [direct contract] + [graduate trainee] + [junior] + [senior] + [manager]

     

     

    Create a measure, use the SUMX function for calculations.

     

    Measure = SUMX('Table', [direct contract] + [graduate trainee] +[junior] + [senior] + [manager])

     

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

Junkay's avatar
Junkay
Regular Visitor
2 years ago

Thanks Ahmedx. I used calculated column and it worked fine.

 

Thank you so much.