Set Analysis

[Anonymous]

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

[Anonymous]

Hi,

Please find the attachment

Thanks,

Leni

[Anonymous]

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.

[#4]

sum({1<Currency=p(Currency)>}Rate)*Amount

[lironbaram · Accepted solution]

have a look

this example work perfectly

[israrkhan]

Hi Leni,

Find the attachment, its working.

and expression is,

Sum({1<Currency = $::Currency>} Amount*Rate)

Regards

Khan

[Anonymous]

Thank you Khan It is working

[Anonymous]

Thank you for the solution It worked