Pivot table - Customized Partial sums

[nihhalmca]

Hi All,

I am attaching sample report here which i need to replicate in QlikView/Qlik Sense.

Note: Please make sure that formula at cell '14' in sample report.

Thanks,

Nihhal

[mdmukramali]

Hi,

it's very simple in Qlik.

Take Pivot table --> Dimensions-->  Dept Group ,Product,Dept Name.

Thanks,

Mukram.

[Anonymous]

Hi,

In Qlik Tech We can do it

Dimension : DeptGroup

                    DeptName

In Presentation select Dept Name And check Show Partial Sums and Subtotals at bottom

PFA Sample

Thanks

[nihhalmca]

Hi Mohammed, Please go through the formula once in sample report. Its not just direct partial sums.

[nihhalmca]

Hi Ritesh, Please go through the formula once in sample report. Its not just direct partial sums.

For instance: As per your snap shot total of depart c1 and c2 should be 245 not 90.

[Anonymous]

!Hi

Do you want like this because if we enable partial sum then it will display partial sum o C as well

Thanks

[nihhalmca]

No Ritesh, exactly i need it as sample report.

[nihhalmca · Accepted solution]

Got it solution by below code.

=If([Dept Group] ='C' and Dimensionality() = 1, Sum(total <Product> Value) ,Sum (Value))