When the user accidently selects both Parent Node and child Node. I want to consider the Parent Node in the filter.
---------------------------------------------------
I have requirement as below. Please suggest.
1) I have a Tree Prompt which is Multi select having 7 levels.
2) User can choose any level from each Category.
3) when the user chooses
a) In a particular category user selects Level 3, in the report we have to show from Level 3 to Level 7 in the report for that category.
b) In another category he may select Level 1 then in the report for that category we have to show from Level 1 to Level 7
For implementing the logic as stated in 3a and 3b - I have used Descendants function.
The Problem is
4) when the user selects in the same group Level 3 and Level 4 (manually) then report is showing
Level 3 to Level 7 Rows - Which is fine
Below to the above rows again from Level 4 to 7 rows are repeated.
As they are in same group I do not want them to be repeated in the report.
Thanks!
Kiran