Please find your solution given below-
Data set as described by you-
As per your requirement, you just need to write a small calculation to count the user entered values by comma, that is---
LEN([V1]) - LEN(REPLACE([V1],',',''))+1
In the above calculation, replace the V1 column name as per your column name and you'll be able to get desired output.
Further, i'm attaching the workbook for your reference.
Hope this will be helpful.
TableauNew Learning .twbx 10.1 KB
I am not able to open this workbook. Will you be able to upload it again?
I got this open after installing tableau 10.
I need to have col values also from user entered values.
As per your requirement you've got the solution, these values are user entered only which you mentioned above, for the dynamic value insertion you need to anyways fetch data into Tableau only. Once you fetch the values input by user you can continue with the above solution.
Hope you've got your answer.