Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
mira el ejemplo.. creo que hablas español
saludos
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
you are right, easy and simple expression in the end...