# New to QlikView

Discussion board where members can get started with QlikView.

Valued Contributor II

## Pivot table - Customized Partial sums

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

1 Solution

Accepted Solutions
Valued Contributor II

## Re: Pivot table - Customized Partial sums

Got it solution by below code.

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

7 Replies
Valued Contributor III

## Re: Pivot table - Partial sums

Hi,

it's very simple in Qlik.

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

Thanks,

Mukram.

Contributor

## Re: Pivot table - Partial sums

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

Valued Contributor II

## Re: Pivot table - Partial sums

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

Highlighted
Valued Contributor II

## Re: Pivot table - Partial sums

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.

Contributor

## Re: Pivot table - Partial sums

!Hi

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

Thanks

Valued Contributor II

## Re: Pivot table - Customized Partial sums

No Ritesh, exactly i need it as sample report.

Valued Contributor II

## Re: Pivot table - Customized Partial sums

Got it solution by below code.

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