How to get a value in the first row?

[#1]

Hi, probably a easy question to good developers.

I need to get the first value of the Pivot table considering the number in the first rown is not always min, max

example below:

	2007	2008	2009
a	10	7	20
b	20	5	15
c	30	2	30
d	40	1	25

and the expected result is

	2007	2008	2009
a	10	7	20
b	10	7	20
c	10	7	20
d	10	7	20

Any help is very appreciated.

Thanks!

LEandro

[fdelacal]

mira el ejemplo.. creo que hablas español

saludos

[swuehl · Accepted solution]

Try the chart inter record functions, namely top():

=top( only(Value))

with only(Value) being the expression you are using so far (or replace with sum(Sales), .. etc.).

See attached.

Stefan

[#4]

you are right, easy and simple expression in the end...