Pivot Table in Nprinting.

[infosense_devel]

Hello,

I have excel template I want to do pivoting for one of my reports I have follow the link below which is suggested by community,

How to Create an Excel PivotTable Report.

But not get desired output.

I got this from my excel,

And I want something like this,

Here I attached my Template.

Thanks In Advance.

[#2]

1. The "level" shouldn't be in the pivot table
2. Try this tutorial instead. It's a more elegant solution:
   
   How to Create a Pivot Table from Excel Table Columns

Best

Aran

[infosense_devel]

Thanks @Aran Nathanson for Quick Replay.

Go through your link it will generating same which I have mentioned prior like,

And what I need is Row label Column like Construction , Industrial and Total Group is left to the table like,

Thanks in Advance.

[#4]

It's an Excel formatting issue.

Go into the design tab in the Excel ribbon and set the formatting the way you want.

If you go into "Report Layout" and select "Tabular format" that should be close to what you want.

However, this is an Excel formatting issue, not an NPrinting/Qlik issue.

Best

Aran

[infosense_devel]

Thanks Aran.

Really Helpful.

Only one concern I followed your steps and Get output like,

Its as per desired only thing is that I want to remove that Values heading from report only want to display sales and Budget.

tried different option on design tab like Unchecking column header but no luck.

I Have set up like,

Thanks for All.