Pivot Table formatting help

[#1]

Hi All,

Greetings for the day!

I have one requirement as i need to display pivot table in custom format as attached file.

I have tried with If conditions in Background color expression but result is not as expected.

I have tried with 'Custom Format Cell' option also and it's not worked.

Could you please anybody give me suggestion on this.

Thanks,

Vamsi

[beck_bakytbek]

Hi reddy,

look at this:

Controlling Colours in Charts - YouTube

Qlikview Create a Pivot Table by RFB 161 - YouTube

Qlikview Pivot Table Subtotal Colors by RFB 166 - YouTube

I hope that can solve your problem

Beck

[#3]

Hi beck,

Thanks for your reply!

But is not the output as I am expecting. Could you please anybody have any idea please share with me here.

Thanks,

Chiru

[tamilarasu]

Did you check the below option in chart properties.!!

If this is not your expectation, check the below link,

Shading every other row in Pivot table

[jagan]

HI,

It is not possible with Pivot Table, you can try with Straight Table.  You can try this by using

Chart Properties -> Style -> Strips Every 1 Row option.

Hope this helps you.

Regards,

jagan.

[Anonymous]

Hi Reddy,

Here is a solution. By customizing the background color of the measure with the expression below, you will obtain the result you want.=>

=> IF(Even(RowNo(TOTAL)), rgb(240,240,240), rgb(0,174,255))

I've added an example in attachment.

Best regards.