Custom Banding in Pivot Table

[sampada0810]

Hi All,

I want to have custom banding in Pivot Table.

I have 3 dimensions and some 5-6 expressions.

Please find the below screenshot:

For Pivot table, I tired using "If(Even(RowNo(),RGB(249,249,249))" in Background Colour of Expressions and Dimensions. It works fine there.

But I do have a fast change option on this grid, so when I am changing this table to Straight table, I am losing the sorting functionality of the straight table.

I want to have custom banding and also don't want to lose the Sorting functionality.

What is the best possible way to achieve this?

[Anonymous]

Hi,

If they require different setups and sorting I will suggest using two charts and show\hide variable to switch between the charts. Use a button or text box that changes the variable which in turn changes the chart that is visible.

Hopefully this helps you.

[sampada0810]

If I go with this approach,

the issue I am facing is:

when I expand all the dimensions in Pivot Table, I am getting distorted formatting.

Please find the image below:

Can I get rid of this?