Calculating only First Rows on a Pivot Table?

[#1]

Hi Qlikies,

I need to calculate only the first rows based on below example:

Reference	Date	Value
Office	2015/03/10	90
Office	2015/03/10	90
Office	2015/03/09	90
Office	2015/03/08	90
Mark	2015/03/10	78
Mark	2015/03/10	55

Any Solution to this?

Regards.

[sunny_talwar]

Not sure what you mean? what ouput are you looking from the above example?

Best,

S

[sorrakis01]

Hi,

You can use a conditional for any expression to do it.

Please If you like explain that you need to calculate...

Thx