Summing Based on Selections for Multiple combinations of Dim values

[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
4	300	100
5	200	100

Expected Output:

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

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

[agigliotti]

what's your goal?

[Ponkaviyarasu]

Are you expecting above result?

[priyalvp24]

Hi,

Try this,

Script Level.

If(Territory No=1 orTerritory No=2,'1+2',

If(Territory No=3,'3',

If(Territory No=4 or Territory No=5,'4+5'))) as [New Territory No]

front end.

table object.

[New Territory No] as dimension

Sum(unit sales) as measure1

Sum(inventory units) as measure2

Please mark if its helpful.

Thanks

[imrasyed]

When User selects combination of territory(for ex : 1,2)  it shd display  as 1+2 with other territories as well in the straight table.

And user has multiple combinations of those(for ex: 3+4 or 5+7) and they are not fixed .

[imrasyed]

Nop,

We need to get 1+2 as well as other territories which are single(i mean not selected) and they have multiple combinations like 3+4 or 5+7 which are not fixed.

[imrasyed]

Hi,

I did that but those territory combination is not fixed .They are dynamic.

Thanks.

[imrasyed]

can any one atleast let me know if such a simple requirement would  able to be  achieved in Qlik?