Sum Values Only Once

[#1]

Dear all,

In advance, thanks for all the comments that you may provide. Here is my situation.

I have this set of values as can be seen in attachment named Foto1

As you can see, for a single brick the values get exactly repeated by each territory calling them. What I'm trying to do is to only sum then once, because if I sum then directly then the values might get duplicated. I've been working around with sum and aggr but no good results came from that.

Guys, any ideas?

Again thanks for your help.

Regards,

Andrés A. Jején P.

[#2]

Hi Anders

But you could create a new table giving you these brick/product related values ignoring the territory. You can still use your "full" table for other diagrams.

Regards

Jürg