I want to ask a question about the totals column in the pivot table.

[sevvalk]

Hello, I added a totals column in the pivot table. And I want to sort by totals column. I also want to make the background of this totals column a different color to further highlight it. I would be happy if you help.

[Rohan]

Hi Sevvalk,

Have you added Totals as a Row or Column ? Depending on that use Dimensionality() or SecondaryDimensionality() to colour your required rows like :

for eg - Pick(Dimensionality()+1,Blue(),white())

This will highlight the Total Row as Blue & remaining as white. Try this out & revert if any issues.

Regards,

Rohan.

[sevvalk]

A

[Rohan · Accepted solution]

Hi,

Since, you are adding the Total as a Column, Use SecondaryDimensionality().

Regards,
Rohan.

[MatheusC · Accepted solution]

Hi, @sevvalk 

1 - To classify the totals you will find the solution in this topic
https://community.qlik.com/t5/App-Development/How-to-sort-pivote-table-in-qliksense-on-Total-column/...

2 – To color the column as already informed by @Rohan  use SecondaryDimensionality(),
In the column you want to color the totals, then enter in Background color expression:

if(SecondaryDimensionality()=0,LightGray())

Att, Matheus

[MatheusC]

@sevvalk 
Did you find the solution?

Close the thread with the accepted solution and leave a thumbs up if you found it useful