Combining Data

[suby]

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.

[atcodedog05]

Hi @suby 

Nice to see you. Expected output snapshot is missing can you please re-provide it.

[suby]

Apologize missed it.

[atcodedog05]

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 : )

[suby]

Thanks for the solution Apologize  just a mistake my expected Output would be something like this.

[ArtApa · Accepted solution]

Hi @suby - Here is how you can do this:

[atcodedog05 · Accepted solution]

Hi @suby 

My approach would be similar to @ArtApa 

Workflow: