Hi,
Here i am trying to combine my PROD STATUS and SUB PROD STATUS as one single Column to get the desired Output as attached.
Attached the expected screen shot is my representation in Tableau where the both status Would be combined.
Attached the sample workflow.
Solved! Go to Solution.
Hi @suby
Here is how you can do it.
Workflow:
1. Using transpose tool converting Prod Status and Sub Prod Status to rows.
2. Using formula adding a count column. Which will be used later.
3. Using crosstab tool Name as key, Value as Name, Count as Value and agg as sum. Converting to table.
Hope this helps : )
Thanks for the solution Apologize just a mistake my expected Output would be something like this.