How to add last two rows of two datasets and create new output.

[areeba]

Hi @atcodedog05 ,

I have 2 data sets

Dataset1

Colour   A   B    C

Red       1   2     1

Blue       2   5     2

Total      3    7     3

Dataset2

Colour       A  B    C

Green        2  2     2

Yellow        1  4     8

Total_C      3   6  10

Desired Ouput:

All_colour           A    B    C

Grand_total        6    13  13

idea is to total last two totals together.

Can you help ?

Regards

Areeba

[atcodedog05]

Hi @areeba 

Would this do.

Workflow:

Hope this helps : )

[areeba]

Hi @atcodedog05 

There is a little change in the requirement

Dataset1

Colour _1                    A  B  C

Red                            1   2   1

Blue                            2  5   2

Total_Dataset1           3  7   3

Dataset2

Colour_2               A B C

Green                    2 2 2

Yellow                    1 4 8

Total_Dataset2      3 6 10

Desired Ouput:

All_colour              A  B   C

Grand_total           6 13 13

[Zas3nfkb]

Add a record ID to each dataset. Sort by Record ID descending, sample first record, union, Summarize, done.

[atcodedog05]

Hi @areeba 

I would suggest positional joining in union for this scenario.

Workflow:

Hope this helps : )

[areeba]

its still not summarizing my data at the end , maybe because of the names are different in new requirement.

Can you use new dataset?

[atcodedog05 · Accepted solution]

Hi @areeba 

I am using data from the new requirement only. I was attached workflow for refrence.

Hope this helps : )

[areeba]

Hi @atcodedog05 

Thank you for the solution , just the last thing

When i am addin these two rows:

It is giving me this result:

But the correct result is :

6.911       6.876       7.185

what am i missing to get this ?

Regards

Areeba

[atcodedog05 · Accepted solution]

Hi @areeba 

Looks like sub total needs to be in decimal like 0.697 instead its in hundreds 697 hence you getting total of around 702.214

[areeba]

@atcodedog05 

At one place i have to show as it is 697 as a result but in total it has to be added like decimal like you said.

do you suggest that in total calculation i have to make this figure as decimal , if yes , then how ?

Or do you have better idea?