How to ccalculate total

[Junkay]

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:

Thanks.

[Junkay]

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

Thank you so much.

[Anonymous · Accepted solution]

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]

I could only see the row total, no column total on the version I'm using

[Ahmedx]

can you show me what your table looks like? I think it’s better for you to create a measure instead of implicit measures

pls see video

https://www.youtube.com/watch?v=f7g6EvNGClQ&ab_channel=RADACAD

https://www.youtube.com/watch?app=desktop&v=2POPWOYQjFo&ab_channel=LearnAtCloudAnalytics

[Ahmedx]

pls try this