Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What exactly did you try? Did you try like this?
Sum({<ID, [Parent ID] = P([Parent ID])>} Amount)
What exactly did you try? Did you try like this?
Sum({<ID, [Parent ID] = P([Parent ID])>} Amount)
Sum({<ID, [ParentID] = P([ParentID])>} total Amount)
Make sense, I think [Parent ID] = P([Parent ID]) is the way to go here