Basic Table - Reporting

[Sarath27]

Hi Team, 

I am trying to convert the below to pivot table type using Basic table tool in reporting, but I could not get the excel type pivot table in the output. I want the output to be like a pivot where user can filter the columns and the respective data should be grouped with respect to the filtering conditions.

Submission Type	Region CF	Prod Level6 PR	P C	Total
FV	Europe	EMEA	47410-2238	2
FV	Asia Pacific	APAC	17462-7758	4
FV	Europe	APAC	89514-2338	6
FV	United Kingdom	EMEA	13687-2772	0

My required output should be as attached

[caltang]

Hi @Sarath27 - I believe this is what you are looking for: https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-1/ba-p/9746... 

[Sarath27]

Yes i followed the same, but I couldn't achieve the expected results. Thats why I am reaching out for a help.

[caltang]

Show us your workflow and we can troubleshoot together. 

[Sarath27]

@caltang I have attached the workflow FYR, please assist me on this. Thanks in Advance.

[caltang]

Now, try with this and customize it from there. Hope this helps!