Concatinate category with custom parameter SAS VA

[balraj]

Hi Community,

I've a Category with values(AS,NA,EU,OC,SA,EF,AF)

I would like use the "Button Bar" to pass input values with values under

label "Mine"="AS",

"All"="AS,NA,EU,OC,SA,EF,AF"

but I'm getting it as "Mine"="AF" and "All" ="AS,NA,EU,OC,SA,EF"

how can i add "AF" to "All" label refer the Image attached.

Kind Regards

Balraj

[MichelleHomes]

Hi Balraj,

To understand your question correctly, you want to include the "AF" category in both labels, Mine and All? A category can only be in one group. Essentially being "AF" and all other category values, mutually exclusive.

Kind Regards,

Michelle

[balraj]

Hi Michelle,

You understood it correctly. If that is the case how can I Implement it. Is there any work around for doing it.

Kind Regards

Balraj

[MichelleHomes · Accepted solution]

Hi Balraj,

I think to achieve what you are after you need to have 2 new data items for 2 button bar objects. Create one as a label with All that has all the categories and create another with just AF by using an expression. Then use the each data items as the underlying data for a button bar object in the report.

Kind Regards,

Michelle