Summing based on Selections

[imrasyed]

Hi Experts,

I have a straight table with Territory Numbers and some Measures like Sum(unit sales),Sum(inventory Units).

Now I need to sum the Total based on selection and simultaneously display entire Table.

Ex:

My  straight Table is :

Header 1	Header 2	Header 3
Territory No	Sum(unit sales)	Sum(inventory Units)
1	100	30
2	20	100
3	500	200

Expected Output:

Header 1	Header 2	Header 3
Territory No	Sum(unit sales)	Sum(inventory units)
1 + 2	120	130
3	500	200

How can we achieve this dynamically i.e up on selection it has to sum up and also display other rows

Really appreciate your kind help

Thanks

Syed Imran

[imrasyed]

Hi Max,

Needed your help once again,

Can we achieve this in multiple rows using different combinations like

1

2+3

4

5

6+7

Thanks for u r kind help

[Anonymous]

Sorry Imran but I can't think of anything interesting.  I'll let you know when I get some.

[imrasyed]

No issues Max.

Thanks for all your help.

[imrasyed]

Hi ,

Can anyone help me out in achieving this?