Printout does not match pivot table properties

[mbourges]

Hi everyone, 

I'm editing a pivot table that I then print on a PDF. I want to hide some of the values in certain columns when they're not the first line of the expression, so I'm using a if statement on the color: if(line_attribute_number>1,RGB(256,256,256)). 

On the sheet that I use to create the objects and manage them, it looks fine; but when I edit the report or print it, the color configuration is not taken into account. 

Correct format

Printout

If any one has a solution or an idea on what to investigate, I'll take it! 

Thanks!

[rubenmarin]

Hi, last color number should be 255, not 256. White is RGB(255,255,255)

[mbourges]

You're right, turns out I'm not consistent and the columns 'Quantity' and 'BOM' had the right color code, not the first few colors. 

Unfortunately that's not solving my issue, thank you nonetheless! 

[rubenmarin]

Can you post a sample that shows the problem? Hope I can take a look later.