Custom total column in qlik sense Pivot Table

[prathamesh5017]

Hi All, 

           I want to add New Customize Total in Qlik Sense Pivot Table.

[vinieme12]

can you please clarify what exactly are you trying to achieve ?

do you want to add another total column or just manipulate values in the existing total column??

[prathamesh5017]

I want to add another total column in Pivot table with manipulation.

[vinieme12]

Here is a reference, the underlying concept is the same

Partial Sums in straight table | Custom Labels in ... - Qlik Community - 1494646

if, you need more assistance; please post some sample data and mockup of expected output?

[prathamesh5017]

Required OutputQlik output

Hi, 

I have added the required output screenshot for your reference and sample qlik output. 

[vinieme12 · Accepted solution]

as below

temp:
load * inline [
Student,Subject,Score
A,English,75
A,Maths,55
B,English,80
B,Maths,70
];

load * inline [
Dim,so_Dim
Student,1
Total,2
AverageTotal,3
];

exit Script;

Row Dimension

=Subject

Column Dimension

=pick(so_Dim,Student,Dim,Dim)

Measure

=pick(so_Dim,Sum(Score),Sum(Score),avg(Score))

[prathamesh5017]

Hi, 

Thanks...👍

I tried with the proposed solution and it worked fine however there are many rows which are required to be total on single table the row to be approx. 68+,  it gives me performance issue and Qlik services goes down. 

If any load tolerance level available to address this issue . 

[vinieme12]

Another option is to have one to many association to the dimension value, if you can upload a sample app that best represents ur scenario; members here can take a look