Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a question,
Is there a way we can disregard all selections except one. For Example, I have an application which has many fields so in that I want one of my chart to show data disregarding of all selections except the selection on currency.
Is there any way we could achieve using set analysis.?
Thanks,
Leni Balakrishnan
Hi,
Please find the attachment
Thanks,
Leni
Hi,
Try something like this
Sum({<field1=,field2=,field3=,....fieldn=>}Sales)
Note :Write all the fields except currency field here as written above in the expression.
sum({1<Currency=p(Currency)>}Rate)*Amount
have a look
this example work perfectly
Hi Leni,
Find the attachment, its working.
and expression is,
Sum({1<Currency = $::Currency>} Amount*Rate)
Regards
Khan
Thank you Khan It is working
Thank you for the solution It worked