Calculated Filter Pane / Set Analysis - Can Only Select One Value

[Anonymous]

Hi there,

I am using the following for a calculated filter pane in Sense:

AGGR(Only({<Publisher_Code = {$(vOWNPUBCODE)}>} "My Publisher"),"My Publisher")

The problem I have is this will only permit selection of one value, or an invalid parameter error appears - probably due to the only function.

Does anyone have a solution / workaround?

Thanks!

[sunny_talwar]

How about this?

Aggr(Only({1<Publisher_Code = {$(vOWNPUBCODE)}>} "My Publisher"),"My Publisher")

[Anonymous]

Perfect, exactly what I needed!!! Thank you!!!!!