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 Suite 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!
