Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jozisvk11
Creator
Creator

Sum of rows in pivot table

I have problem with Pivot table. I need tu add sum of rows. (red column)

For example:

  

IDID - descriptionJanuaryFebruaryMarchTotal
N10170001Work A2 714,61 €5 732,75 €5 438,18 €13 885,54 €
N10170002Work B1 522,42 €806,02 €1 305,39 €3 633,83 €
N10170004Work C--194,21 €194,21 €
N10170005Work D2 805,09 €149,54 €1 603,27 €4 557,90 €
N20170001Work E-184,95 €-184,95 €
N30170001Work F289,68 €795,20 €405,11 €1 489,99 €
N40170001Work G2 569,38 €1 960,08 €1 842,03 €6 371,49 €
N40170002Work H9 132,78 €7 950,25 €6 346,10 €23 429,13 €
N40170003Work I7 103,93 €3 358,46 €4 064,77 €14 527,16 €
N50170001Work J372,31 €544,93 €566,39 €1 483,63 €
N50170003Work K166,06 €119,52 €-285,58 €
N60170001Work M428,63 €544,26 €1 337,47 €2 310,36 €
Total27 104,89 €22 145,96 €23 102,92 €

Total of colums can do with partial sum. But I also want total of rows. Can anyone help me ?

Thank you

1 Solution

Accepted Solutions
Anonymous
Not applicable

So you are using Month as column dimension in the table??  Then go to the Presentation, Select  your field in Dimensions and Expressions and check partial sum.

View solution in original post

2 Replies
Anonymous
Not applicable

So you are using Month as column dimension in the table??  Then go to the Presentation, Select  your field in Dimensions and Expressions and check partial sum.

gerry_hdm
Creator II
Creator II

sum(sum(.......)

then see you the sum .-)