Struggling with summarizing and totals

[matiasalbacetti]

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.

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.

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!

[v-danhe-msft]

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

[d_gosbell · Accepted solution]

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

[matiasalbacetti]

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]

---

@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 🙂