"Double Selection" or Selection step by step

[Micki]

Hi folks, 

I have a question, based on the first selection in my case 4944 expression should use value 4789 and paste it in selection 

so at the end should be two values in selection. Does anybody know any similar solutions ? 

[chrismarlow · Accepted solution]

Hi,

You might be able to use P() function to union the possible values from the selection, so;

Avg({<[Fact_WI.WorkItemID]=P([Fact_WI.ParentWorkItemID])>+<[Fact_WI.WorkItemID]=P([Fact_WI.WorkItemID])>}1)

In my toy app seems to give something like you describe;

Cheers,

Chris.