Create pivot table on Nprinting pixel perfec

[c_pannese]

Hi All,

is possible to create a pivot table in pixel perfect?

I've create straight table with data to use but i can't realize a pivot in pixel perfect.

thank you all.

[Lech_Miszkiewicz · Accepted solution]

Hi, 

There is no pivot table feature.

You can only mimic pivot table look by hiding showing cell values and borders around cells using straight table.

If you were thinking about adding dimension as a column - then this is not possible.

cheers

[Dadiop]

Hi,

As said by @Lech_Miszkiewicz you can only mimic pivot table look.

You can achieve that by creating a nested level in Pixel Perfect.

https://www.youtube.com/watch?v=kR9K04RFX8o

You can take a look at this video, it can be used as a "beginning template". With some custom (background color, borders, etc.) you should be able to do your own pivot table.

Depending on your application, you will maybe have to create calculated field for the subtotal and total (That was my case).

Here is just a little preview of my pivot table done on Pixel perfect (97% same as in QV)

It's not an easy work, but it's definitely possible. You can also use formatting rules in case you need to modify colors etc.