particular cell summation

[srujanaponnuru]

Hi,

The below data is shown as:

Asset   Class	Position	Stress Test   Values
Equity	position1	-699
Equity	position2	-118
Equity	position3	-972
Derivatives	position4	-870
Derivatives	position5	-63
Derivatives	position6	-884
Fixed Income	position7	-98
Fixed Income	position8	-73
Fixed Income	position9	-242
Forex	position10	-398
Forex	position11	-50
Forex	position12	-659
Forex	position13	-474
Commodities	position14	-190
Commodities	position15	-632
Commodities	position16	-533

I want a pivot table to calculate the sum of stress test values only for equity type , derivatives etc separately.

example:  for equity I want the summation of position 1 + position 2 + Positiion 3 (I,e  = (-699+(-118)+-(-972))

Please help me out.

REgards

Srujana

[qlikmsg4u]

Is this you want...please tell us the requires output

[alex_millan]

Hi again,

If you can switch the order of some of the columns, you can set the dimensions on the left and the calculations on the right:

As Dimensions:

- Portfolio

- [Asset class]

- Position

As expressions.

Sum x portfolio = Sum(TOTAL <Portfolio> [Stress Test Values])

Sum x asset class = Sum(TOTAL <[Asset class]>[Stress Test Values])

Sum x position = Sum([Stress Test Values])

HTH

Regards,

[srujanaponnuru]

Hi,

I should get fields in a pivot table as Asset class, Position thru these two fields I need to calculate Column L from Column N.

[antoniotiman]

Hi this is what You want ?

See Attachment

Regards

[srujanaponnuru]

Hi  AntonioTiman,

Yes, but I have so many positions and Asset classes, I cant mention all the positions in that expression. Is there any other way to do it ?

any way thank you for your help.

regards

Srujana

[Kushal_Chawda · Accepted solution]

Please see the attached.

This is what you are looking for

[antoniotiman]

Change expression to

Sum({<[Asset Class]={'Equity'}>} [Stress Test Values3])

[srujanaponnuru]

Hi Kush,

thanks a lot for your help. It worked.

Regards

Srujana

[Kushal_Chawda]

srujanaponnuru‌  have you seen the application which I have attached