Table row - color , format & left indentation.

[#1]

Hi,

I need your help

Below is the attached image

I have 3 questions here

1. As you all see, if i select left alignment on presentation section for batman columns, the results come very close on the left side, which doesn't appear good. Can we left intend as shown in the image?

2. How to highlight the entire row with blue color in the pivot table?

3. How to bold the entire row with bold in the pivot table?

I have already used CUSTOM FORMAT CELL option, but not getting desired results.

Regards,

Kuldeep

[#2 · Accepted solution]

hi!

1) you can create field with concatenated '   ' before the data. See it in script. You can keep original field for better looking slicers for example

2) near every dimention and expression you need to press '+', select 'background' and white something like

if( (which row to select) = (which value to select), rgb())

3) see (2): you need to choose 'text format' now and white something like if( (which row to select) = (which value to select),'<B>')

[#3]

Hey Thanks so much.

This is perfect.

Regards,

Kuldeep