Background Color issue in Pivot Table in Total Row

[#1]

Hiii alll,

I am using background color expression in Pivt tables but this expression is not working on Total row.

Please help me on this.

Thanks & Regarda

Prince Anand

[ashfaq_haseeb]

Hi Anand,

Did you try by custom format cell?

Go to Setting --> user Preference --> Design tab --> and select always show design menu item --> ok.

Now right click on total row in your chart --> click on custom format cell.

Play with the settings here.

Regards

ASHFAQ

[#3]

Dear Ashfaq,

thanks for your response.

But I want to show total row background volor with some expression because by using custom format cell the background color will be fixed but i want dynamic color.

Thanks & Regards

Prince Anand

[ashfaq_haseeb]

Hi,

Anand there is condition color option available in custom format cell.

have a look at attached image.

Regards

ASHFAQ