Subtotal of selections

[#1]

Hello Guys, I need advice from you!

Below model of my problem.

A simple table would show the subtotal of selections as clusters ...

example:

A = ...(If I do not make any selections in A1: A3, the result is 30, if you select A1 and A2 (eg.) The result is 20)

A1 = 10

A2 = 10

A3 = 10

B = ...(If I do not make any selections in B1: B3, the result is 30, if you select B3 (p. ex.) The result is 10)

B1 = 10

B2 = 10

B3 = 10

or

A = 30

A1 = 10

A2 = 10

A3 = 10

B = 30

B1 = 10

B2 = 10

B3 = 10

or

A = 20

A1 = 10

A2 = 10

B = 10

B3 = 10

Any help will be appreciated!

Stive!

[spividori]

Hi.

If I understood correctly the problem, I attached a file of how I would solve it.

Regards.

[#3]

Sandro Thanks for listening!

I need to show all the information on the same chart!

A = 20

A1 = 10

A2 = 10

B = 10

B1 = 10

What do you think?

Stive

[spividori]

And if you change a pivot table, add Fld2 as second dimension and place it: "Show partial sum" for this?

Regards.

[#5]

It would be nice, but it is not as my client ...

Thank you!

[spividori]

You could upload a picture or attach a file of how the result would.

To understand better.

Regards.

[#7]

attached

[#8 · Accepted solution]

Through Aggr managed to solve the problem.

Attached is the solution I found. It's just that I'm applying a model in another context.

The summary is this:

Records that has a number are children of another upper register.

Example: "A1" son of "A" and so on

1) When I do not select anything, the father should indicate the sum of the children.

2) When I select one or more records sons and his father, the father should indicate the sum of the children.

3) When I select one or more children, show them the value normally.

4) When I select only the father, he should indicate the sum of the children.

Stive

[spividori]

Hi.

Well, I could not understand what you need, but you has solved it, congratulations!.

Regards.