Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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