Pivot table report format

[wenyg]

How to generate the pivot table output into an excel?

I put the following but when I open the excel output, the table doesn't show up but the output from browse tool looks correct.

[DavidSkaife]

Hi @wenyg 

To output data from a Reporting tool you need to use the Render tool 

configured like below for Excel

[binuacs]

@wenyg use the Render tool instead of the output tool to get the table result into excel.

[wenyg]

hey that's the only option I have fir output mode and didn't give me the choice to link to a output file.

[DavidSkaife · Accepted solution]

@wenyg 

Scroll down, it's at the bottom - you need to pick 'Choose a specific output file' and select excel from that