Alternate of P() function

[sagarjagga]

Hi All,

ID	Parent ID	Amount
1	a	100
2	b	200
3	a	300
4	c	400

Above is my Data set. My requirement is like , if i select the ID = 1 in filter , then i need to display the data for the parent ID coming under 1. Below should be my resultant table. 

Parent ID	Sum(Amount)
a	400

I can achieve this my using P() function and Getfilterselection function but by default Getfilterselection will return null.

Any suggestions what could be the alternative of this.

[sunny_talwar · Accepted solution]

What exactly did you try? Did you try like this?

Sum({<ID, [Parent ID] = P([Parent ID])>} Amount)

[sagarjagga]

i was using set expression like , Sum({<ID, [Parent ID] = P({<ID={"$(=Getfilerselection(ID))"}>}[Parent ID])>} Amount)

[sugathirajkumar]

Sum({<ID, [ParentID] = P([ParentID])>} total Amount)

[sunny_talwar]

Make sense, I think [Parent ID] = P([Parent ID]) is the way to go here