How to make specific rows "non-expandable"?

[#1]

I have a pivot table with five columns:

RR_RAD1 - RR_RAD2 - VERKSAMHET_NAMN - AKTIVITET - KONTO

I would like to make specific rows (rows with value ’11’, ’13’ and ’15’) to be “non-expandable”. These rows should only show the value for RR_RAD1 but not for the other columns (RR_RAD2 - VERKSAMHET_NAMN - AKTIVITET – KONTO).

Example:
RR_RAD1 RR_RAD2 VERKSAMHET_NAMN AKTIVITET KONTO AMOUNT
2 rad 2 verksamhet1 akt231 4155 10306,20
3 rad 33 verksamhet11 akt232 4255 10603,44
11 12222,33
12 rad 5489 verksamhet123 akt234 4455 44555,99
13 15252,87

One more question – is there a way to colour one whole row if the column RR_RAD1 has a specific value (i.e. ‘13’ as above)?

Thanks in advance,

Tobias.

[Miguel_Angel_Baeyens]

Hi Tobias,

To your first question, there is none. If chart is a pivot table and "Always fully expanded" is not marked, all possible values are expandable/collapsable.

If you want to make one row having the same color, you will have to expand all dimensions and expressions using the [+] sign at the left of the name and set the same Background Color for all of them.

If(Value = 13, RGB(10, 0, 200))

Hope that helps.

Miguel