topic Re: Close color gap in pivot table's TOTAL row in App Development

Close color gap in pivot table's TOTAL row

Kellerassel — Wed, 16 Feb 2022 08:02:34 GMT

I have a pivot table like the one in the picture. The fields are colored according to their dimensionality.

But as you can see the Total row has a gap.

How can I fill that gap with the same color?

I'm open to any solution including custom themes or injected CSS.

Any help would be greatly appreciated.

Re: Close color gap in pivot table's TOTAL row

chris_djih — Thu, 17 Feb 2022 09:09:38 GMT

It is not a real solution, but when you switch the visualisation to "ident rows" (under presentation),
there are no gaps. IMHO "ident rows" is overal the more beautiful representation:

Re: Close color gap in pivot table's TOTAL row

Kellerassel — Thu, 17 Feb 2022 09:32:22 GMT

Thanks for your reply. Yes, I was aware of that option. But part of me wanting to solve this problem is that 1. my users prefer unindented dimensions and 2. I'm really curious as to what might be the solution for this. 😄

Re: Close color gap in pivot table's TOTAL row

Kellerassel — Wed, 02 Mar 2022 09:52:50 GMT

I have found a solution using CSS. I inject the CSS via the Multi KPI Object using Styles

.qv-object-pivot-table tr:nth-child(3) { background-color: #131d3b5c; }

The Totals-row is the 3rd row (and thus "child") in the table-HTML of the Pivot Table. And I can set a background-color for that row.

It looks so much better now: