Qlik Sense Total column

[paulwalker]

Hi Community,

Any work around Total row bring to bottom in Pivot Table Qlik Sense?

[paulwalker]

If anybody has experience on similar issue - please do let me know...

[vinieme12]

Add a dummy dimension value 'Total'

refer below

https://community.qlik.com/t5/QlikView-Documents/Partial-Sums-in-straight-table-Custom-Labels-in-Piv...

[vinieme12]

Load * Inline [ 

Dim

1

2];

Chart Dimension = Pick( Dim, Your dimension,'TOTAL')

Chart expression for MTD

=pick(Dim,sum(MTD), sum(TOTAL MTD))

and so on