# New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

## Ignoring second dimension

Hello. Sorry, my english is bad, but I hope I would be understood.

I have one table:

a,b,c,d

mor,one,6,one

mor,two,323,two

mor,three,543,two

];

I want to create pivot table like this:

a,b,sum(c) for a dimension ignoring b

mor,one,872

mor,two,872

mor,three,872

I can't write function for this table.

Tags (4)
1 Solution

Accepted Solutions
Not applicable

## Ignoring second dimension

You should use "Sum(Total" specifying the dimenson to "total-on".

In your case the dimensions should be "a" and "b" and the expression should be "sum(total<a> c)"

Best

Francesco

3 Replies
Not applicable

## Ignoring second dimension

Hi,

you want a pivot table with the result:

mor 872

?

Then your dimension is only 'a' and the expression is 'sum(c)'.

Or you collapse the dimension 'b' in the pivot table by clicking on the column 'a' and saying 'Close the dimensions behind'.

regards

vicky

Not applicable

## Ignoring second dimension

You should use "Sum(Total" specifying the dimenson to "total-on".

In your case the dimensions should be "a" and "b" and the expression should be "sum(total<a> c)"

Best

Francesco

Not applicable

## Re: Ignoring second dimension

This is solution for my problem.