Pivot Like format with repeated values on page break

[paolo_cordini]

Hi,

my client would like a table like this example in NPrinting.

The problem here is that the values in columns "Sales Type" and "Country" should be centered vertically and they should be repeated on page break.

I tried in several ways but I couldn't get this behaviour with Excel template (both with native excel pivot and using levels) and PixelPerfect template.

Does anyone have some ideas about?

Thanks 

Regards
Paolo

[Jacob_Poole]

I'm not sure if this will be the best solution, but I've encountered a similar request to have the labels centered.  

In the excel template, pivot table options did you try this checkbox? 

[paolo_cordini]

Hi,

yes, I tried but unfortunately this flag centers the labels both vertically and horizontally. This makes the table less readable, I need them to be Left aligned. Furthermore, I need the labels to be repeated on page breaks, because they could span a lot of rows. This is apparently impossible with excel pivot.

Thanks

Paolo

[paolo_cordini]

So, bottom line: there is no solution for this requirement.....

[David_Friend]

@paolo_cordini I would agree that unfortunately I don't see a way to accomplish this, perhaps reach to to your Partner Manager and get some time with Qlik Professional Services?