Pivot table as per excel pivot

Question

Hi,

I'm trying to create a pivot form excel output & change the background color & bold the Header and footer.

I've mentioned in excel.

I tried to use Table & render tool option but its not working as expected output and the output should be saved in the file with Tab name.

Book1.xlsx

caltang · Answer

There is one way to do it this way:

For joshikalyani.yxmd

caltang · Answer

Before we proceed with your problem, can you export your workflow here? Let's see what you've done so far and we can build on that so you can learn better as well.

Other than that, please note that Alteryx's pivot equivalent may not look exactly as how an Excel pivot table will look like especially if you have multiple dimensions and measures.