Row Total in Pivot Table of Qlik Sense

[mahmooddba]

Hi,

I would like to get row total in pivot table as a measure based on dimension please find the attachment for reference of my requiremen

Thanks!

[sunny_talwar · Accepted solution]

Try this

Sum(TOTAL <SITE, BRAND> [SALES VALUE])

[devarasu07]

Hi,

You can do it in both way (fornt/back end side). which side u wanted apply that logic? if u are going to use this measure in many chart object better do it at back end else front end.

method 1:

as sunny suggestion by using the total and group by class

sum( total <SITE, BRAND> [SALES VALUE])

method 2:

Fact:
LOAD * INLINE [
    SITE, BRAND, PRODUCT SUB CATEGORY, SALES QTY, SALES VALUE
    100, PAL, CONTOURING, 24, 1943
    101, PAL, CONTOURING, 31, 2113.25
    102, PAL, CONTOURING, 22, 2026
    100, PAL, FOUNDATION, 7, 390
    101, PAL, FOUNDATION, 3, 192
    102, PAL, FOUNDATION, 5, 380
];


join (Fact)
load SITE, BRAND, sum([SALES VALUE]) as CTS Resident Fact Group by SITE, BRAND;

o/p

[mahmooddba]

Thank you very much!

[mahmooddba]

Hi,

Thanks for your time and response unfortunately i can't mark your response as correct answer as i already marked for Sunny.