Dynamic search in set analysis

[#1]

I have the following calculated dimension:

=aggr(only({

< InvoiceID=P({<Payment={'$(vRule01)'}>} InvoiceID )>

*

< InvoiceID=P({<Payment={"=replace(Payment,'.',vRule02)"}> } InvoiceID )>

*

< InvoiceID=P({<[Purchase Type]={'$(vRule03)'}>} InvoiceID )>

*

<InvoiceID=P({<InvoiceID={"CreatedBy=ChangedBy"}>} InvoiceID)>

)

} InvoiceID) ,InvoiceID)

What I need to do here is to replace the hard-coded "ChangedBy" field in the last set analysis, with a variable such as vRule04, where depending on some other external events would pass the ChangedBy field or some other field (like ApprovedBy)  to the set analysis.

Can someone provide the correct syntax.

[rwunderlich · Accepted solution]

I think it would be

CreatedBy=$(vRule04)

Have you tried that?

-Rob

[#3]

Had tried it before posting this with no success. Tried it again after your suggestion and now it works!. Thanks for your response and time.