topic Re: Pivot Table - Display 'Totals' by Row in App Development

Pivot Table - Display 'Totals' by Row

satya_s — Fri, 26 Jan 2024 13:01:29 GMT

Hello,

In Qlik Sense, I am using the Pivot Table and would like to include a 'Total' Column which shows the totals by each row for the year-month figures as shown below. How can I achieve that?

The Dimensions are SPProductCode, RoutingDestination, Column (Year-Month), Measure is Volume

I see a few responses where the solution is to add an expression, maybe something like

Sum(Aggr(Sum(Volume), SPProductCode,RoutingDestination))

1. Is the above expression correct?

2. Where do I need to add the expression to get a 'Total' column which displays the sum of volume by SPProductCode and RoutingDestination (for all Year-Month's)?

Thanks

Re: Pivot Table - Display 'Totals' by Row

Pierrick — Fri, 26 Jan 2024 14:22:08 GMT

Hello @satya_s,

You can just use your measure : Sum(Volume), and in your dimension Year-Month, you can check the box : Show totals.

Re: Pivot Table - Display 'Totals' by Row

satya_s — Fri, 26 Jan 2024 14:43:02 GMT

@Pierrick Thank you so much. That was easy !! Lot to learn..

Re: Pivot Table - Display 'Totals' by Row

Pierrick — Fri, 26 Jan 2024 15:05:30 GMT

No worries. There are a lot of little parameters to know, which come with experience!
Have a nice day!

Re: Pivot Table - Display 'Totals' by Row

gq — Tue, 15 Apr 2025 16:16:22 GMT

I had similar issue and it is solved with your solution, thank you very much.