Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have problem with Pivot table. I need tu add sum of rows. (red column)
For example:
ID | ID - description | January | February | March | Total |
N10170001 | Work A | 2 714,61 € | 5 732,75 € | 5 438,18 € | 13 885,54 € |
N10170002 | Work B | 1 522,42 € | 806,02 € | 1 305,39 € | 3 633,83 € |
N10170004 | Work C | - | - | 194,21 € | 194,21 € |
N10170005 | Work D | 2 805,09 € | 149,54 € | 1 603,27 € | 4 557,90 € |
N20170001 | Work E | - | 184,95 € | - | 184,95 € |
N30170001 | Work F | 289,68 € | 795,20 € | 405,11 € | 1 489,99 € |
N40170001 | Work G | 2 569,38 € | 1 960,08 € | 1 842,03 € | 6 371,49 € |
N40170002 | Work H | 9 132,78 € | 7 950,25 € | 6 346,10 € | 23 429,13 € |
N40170003 | Work I | 7 103,93 € | 3 358,46 € | 4 064,77 € | 14 527,16 € |
N50170001 | Work J | 372,31 € | 544,93 € | 566,39 € | 1 483,63 € |
N50170003 | Work K | 166,06 € | 119,52 € | - | 285,58 € |
N60170001 | Work M | 428,63 € | 544,26 € | 1 337,47 € | 2 310,36 € |
Total | 27 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
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.
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.
sum(sum(.......)
then see you the sum .-)