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.
