Ignoring second dimension

[#1]

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

I have one table:

LOAD * INLINE [

a,b,c,d

adam,one,43,one

adam,two,655,one

adam,three,56,two

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

adam,one,754

adam,two,754

adam,three,754

mor,one,872

mor,two,872

mor,three,872

I can't write function for this table.

[#2]

Hi,

you want a pivot table with the result:

adam 754

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

[#3 · Accepted solution]

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

[#4]

This is solution for my problem.