cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
matiasalbacetti Frequent Visitor
Frequent Visitor

Struggling with summarizing and totals

Hi there

 

I'm working with a merged query. For each date and person, I'm supposed to see the sum of VALUE1 and VALUE2 without summarizing. Since VALUE1 comes from the merging, there might be multiple rows with different values of VALUE1 but same value of VALUE2, for each date and person.

 

This screenshot shows the table as it is supposed to be displayed.

 

tablaok.png

Here, VALUE2 is not summarized and VALUE1 is getting summed. The problem with this table is that I don't get to see the total of VALUE2. What I need is to see, in the footer, the sum of the values of VALUE2 that are being displayed there.

 

 

This is the output if I set VALUE2 to summarize as SUM.

tablanook.png

As you can see, two rows now show 14 instead of 7, which is wrong. Those rows belong to the dates in which there are two ocurrences of VALUE1. Now I can see the total ov VALUE2 but it's not showing correct information, since two items are being duplicated.

 

 

How can I get to see the first table with the sum of VALUE2 in its footer?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
d_gosbell New Contributor
New Contributor

Re: Struggling with summarizing and totals

Could you do a SUM of VALUE1 before merging the queries so there is only 1 row for each of VALUE1 and VALUE2 ?

4 REPLIES 4
Community Support Team
Community Support Team

Re: Struggling with summarizing and totals

Hi @matiasalbacetti ,

What is your orginal tables befor you merged the two tables? And could you please post a whole desired table that I could test for you?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
d_gosbell New Contributor
New Contributor

Re: Struggling with summarizing and totals

Could you do a SUM of VALUE1 before merging the queries so there is only 1 row for each of VALUE1 and VALUE2 ?

matiasalbacetti Frequent Visitor
Frequent Visitor

Re: Struggling with summarizing and totals

Hi!

 

I don't know if this is what you meant, but your answer helped me. I solved it by grouping the columns in the "Edit queries" section instead of struggling with the table/matrix visual.

d_gosbell New Contributor
New Contributor

Re: Struggling with summarizing and totals


@matiasalbacetti wrote:

Hi!

 

I don't know if this is what you meant, but your answer helped me. I solved it by grouping the columns in the "Edit queries" section instead of struggling with the table/matrix visual.


That's exactly what I meant Smiley Happy