Pivot tables and sums

[schmidtj]

Hi,

i have a quick beginner question to pivot tables in Qlik Sense.

Below you see a simple example with a year dimension and a order number dimension.

I saw that you can set to show sum values in the dimension settings - this is always calculated per row though.

However i would like to have a sum over each column in other words the row SUM is my goal.

Can anybody explain to me how to do this?

	2017	2016	2015
Order 1	1	4	7
Order 2	2	5	8
Order 3	3	6	9
SUM	6	15	24

[vinieme12 · Accepted solution]

read this thread

Partial sum in qliksense pivot  table

enable total for both dimensions and see

[schmidtj]

Ok so i can only do that when i enable sums for both dimensions.

That works, thanks.

Its just a little confusing with a big pivot table since you can quickly mix up a sum value and a value for the metrics.

Is there a way to for example set the background color of the sum values?

[vinieme12]

Use color by expression and use the dimensionality() value or rowno()

If(rowno() = 0, blue())

Total row has rowno 0, also try with dimensionality() or secondarydimensionality()