Pivot Tables Design

Hello!

Can anyone tell me how can I format a Pivot Table with 5 levels. I try to use the "Design" but it only format the first 2 levels of the Pivot Table. I need to distinguish each level with different colors. I think manually is a bit difficult.

Hi,

What you mean by format 5 levels? Can you please mock the desired output and post it here?

Thank you for your reply!

If you open the file in attach you understand what I mean by 5 levels. As you can see in the example, only the first level (Level A) is formated, as well the other sublevels. This is very useful to distinguish the levels when you have a lot of data. The problem is that I don't know how can I do that. The only way is format line by line?

Thanks!

Hi,

This can be done by duplicating the current in-built designs and modifying them. Please go through the following URL and the attachments for more details on this.


http://www.quepublishing.com/article...88532&seqNum=3


Regards,
Chandra

Hi,

As far as can understand, the maximum of Row SubHeadings that I can format is 3. If I have 5 Row SubHeadings, like the example, how can I format the last 2?

Regards
Pedro

That's what I suspect.
Thank you all for the answers.

Regards
Pedro