# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Did you mean:
Highlighted
Contributor II

## Row Total in Pivot Table of Qlik Sense

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!

1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Row Total in Pivot Table of Qlik Sense

Try this

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

4 Replies
Highlighted
MVP

## Re: Row Total in Pivot Table of Qlik Sense

Try this

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

Highlighted
Master II

## Re: Row Total in Pivot Table of Qlik Sense

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:
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

Highlighted
Contributor II

## Re: Row Total in Pivot Table of Qlik Sense

Thank you very much!

Highlighted
Contributor II

Hi,