# New to QlikView

Discussion board where members can get started with QlikView.

Contributor III

## Partial Sums in Pivot Table

Hi

I am using the following Pivot table in my dashboard, The user wants to see Total only if there is more than one Purchase Order coming under a customer.

In the above example I want to show Total only for the Customer 'Smith' and not 'Greyson'.

Is there a way to do so?

Thanks

1 Solution

Accepted Solutions MVP

## Re: Partial Sums in Pivot Table

Try like:

If(Dimensionality()=1 and Count([Purchase Order])>1,Sum(Sales), if(Dimensionality()>1, Sum(Sales))) 3 Replies MVP

## Re: Partial Sums in Pivot Table

Hi Koushik,

Try,

If(Dimensionality()=1 and Customer='Smith', Sum(Sales),

If(Dimensionality()<>1, Sum(Sales)))

Edit:

If(Dimensionality()=1 and Count(Order_Type)>1, Sum(Sales),

If(Dimensionality()<>1, Sum(Sales))) MVP

## Re: Partial Sums in Pivot Table

Try like:

If(Dimensionality()=1 and Count([Purchase Order])>1,Sum(Sales), if(Dimensionality()>1, Sum(Sales)))  MVP

## Re: Partial Sums in Pivot Table

Use this calculated dimension:

Aggr(If(Count([Purchase Order]) > 1, Customer), Customer)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein