I have created a multiselect parameter which has values like Sales,Profit,Quantity,etc.
I have a pivot table which has few dimensions like category,sub category,etc.
When I select sales from the parameter, the pivot visual should show sales in the values.
When I select sales and profit from the parameter, the pivot visual should show sales and profit in different columns.
When I select all the values from the parameter, the pivot visual should display all the values in different columns. It should keep adding based on selected values from the parameter.
I get the below error while writing calculated field.
I tried the below answer, however, it is not giving expected output. When I select sales, it gives sales, when I select profit it gives profit, when I select sales and profit, it gives only profit and not sales. I want two columns one with sales and another with profit. The columns should dynamically add based on values selected.
Nice seeing you back in the Quick Community! I can definitely understand your frustration with the error, as many people encounter it with many different problems, but it does not make it clear. In the post you linked here, I saw you did not use the in() wrapper like the solution did for your condition, so I would definitely recommend trying that to see if it works.
If not, I would definitely check out this post, as it provides guidance on how to set up values with multiple fields.
Thanks for the further clarification on your issue. If possible, could you send me a link to an Arena View of your analysis (anonymized data if necessary), as that will allow me to work with your fields and better see if there is a workaround. Here is a link on how to do so!
Hi @Kripa,
I feel like I recall a similar community post that had the same requirement, though I’m currently having trouble locating this prior post. The tricky thing with this is that you’ll still need to account for each column that could potentially be filled. So if you have 8 options, you may need 8 calc fields that are designed to recognize each.
Let me try and test out a few scenarios to see what I can come up with, I’ll try to get back to you as soon as possible.
Apologies for the delay in my response. I think the post listed here is the one Brett is referring to. Let me know if the solution provided there populates the other columns from your multiselect parameter.
If not, I will take another look at your Arena view to see if there is another workaround.
It’s been awhile since we last heard from you on this thread; did the shared post above help with your scenario or did you have any additional questions?
If we do not hear back within the next 3 business days, I’ll go ahead and mark the solution.
Since we haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.
