How to create Adhoc reporting using field values

[Lakshmanudui]

Hi All,

I am trying to create  adhoc report using field values.

I have fields like Products, Category, Sub Category like that.

But Category field having 3 values like Office, Infrastructure and Material.

There is no separate dimensions for Category values.

My Requirement is if I select Products then show products data and If I select Category like Office then showing Office in Separate column and if i select Infrastructure then shown in separate column and Material also having same thing .

But Office,  Infrastructure and Material there is no individual field.

I am trying to create Separate columns in Scripting side like using pick(Match)) Function.

Pick(Match(Category, 'Office'),'Office') as Office

Same thing i have created remaining values.

But it is not working properly. If i select Multiple selections in Category values then data won't be shown.

If I select single value it will work.

In the same way Sub Category also having multiple values.

Can you please suggest me how to achieve this scenario.

Thanks & Regards,

Lakshman

[MayilVahanan]

Hi

Instead of separate fieldname, create the individual expression by using set analysis and display it based on Conditional expression.

GetselectedCount( Category ) >0 and SubStringCount(Concat(Category,'|'),'Office')

[Lakshmanudui]

Hi Mayil Vahanan,

Thanks for your replay.

I am trying but single selections it will work, but Multiple selections it won't work.

If possible can you share example.

Thanks & Regards,

Lakshman