Totalling horizontally and vertically

Hi ,

I Have 3 Columns :

For eg:

1)Employee type

2)Digit ( it is in v_wstring because it had prior calculations and conversions.)

3)Department

I want to make a table in which i want to calculate the total(horizontally and vertically) on the basis of department who is associated to Employee type and digit.

Please find attached Input file and expected output file for more clarification

Can you help?

Thanks

Areeba

Expected_Output.xlsx

Input_File.xlsx

Datasets

Accepted answers

atcodedog05

Hi @areeba

Here is the updated workflow

Output

Check and let me know.

total.yxmd

atcodedog05

Hi @areeba

In this select tool change fixed decimal 19.2 to 19.2

Hope this helps 🙂

total (1).yxmd

atcodedog05

Hi @areeba

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

total (4).yxmd

All comments

Per

Hi @areeba

For changing the structure of the data to fit your purpose, you need to use the Cross Tab tool which will get you what you need, minus the grand totals.

I do not think there is a nice way to get the grand totals formatted as you asked for, but please see the attached workflow for one suggestion how it can be done