Pivot Table - Display 'Totals' by Row

[satya_s]

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

[Pierrick · Accepted solution]

Hello @satya_s,

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

[satya_s]

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

[Pierrick]

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

[gq]

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