Hello All
We have an Earnings table like this:
Date Symbol Reported EPS
22-01-2013 GOOG $10.59
22-01-2013 IBM $5.39
24-01-2013 MSFT $0.76
28-01-2013 YHOO $0.32
16-04-2013 YHOO $0.38
18-04-2013 GOOG $11.58
18-04-2013 MSFT $0.72
18-04-2013 IBM $3.00
16-07-2013 YHOO $0.35
17-07-2013 IBM $3.91
18-07-2013 GOOG $9.56
18-07-2013 MSFT $0.66
15-10-2013 YHOO $0.34
16-10-2013 IBM $3.99
24-10-2013 MSFT $0.62
And a pivot table with a Calendar[FullDate] on filter context and a SymbolKey[Symbol] on the row context.
We´re trying to return the Last values ("Date" and "Reported EPS") from the Earnings table that are in the period from the selected Calendar[FullDate] to 63 trading days back.
(In that period it should be only one row for each symbol in the Earnings table) (trading days are marked as 1 in the Calendar table).
The sample spreadsheet is here:
https://www.mediafire.com/?ls7bos8gm5c8ub4
(not really sure if Lastnonblank will do the work.)
I appreciate any help that you can provide.
Thanks in advance.
We have an Earnings table like this:
Date Symbol Reported EPS
22-01-2013 GOOG $10.59
22-01-2013 IBM $5.39
24-01-2013 MSFT $0.76
28-01-2013 YHOO $0.32
16-04-2013 YHOO $0.38
18-04-2013 GOOG $11.58
18-04-2013 MSFT $0.72
18-04-2013 IBM $3.00
16-07-2013 YHOO $0.35
17-07-2013 IBM $3.91
18-07-2013 GOOG $9.56
18-07-2013 MSFT $0.66
15-10-2013 YHOO $0.34
16-10-2013 IBM $3.99
24-10-2013 MSFT $0.62
And a pivot table with a Calendar[FullDate] on filter context and a SymbolKey[Symbol] on the row context.
We´re trying to return the Last values ("Date" and "Reported EPS") from the Earnings table that are in the period from the selected Calendar[FullDate] to 63 trading days back.
(In that period it should be only one row for each symbol in the Earnings table) (trading days are marked as 1 in the Calendar table).
The sample spreadsheet is here:
https://www.mediafire.com/?ls7bos8gm5c8ub4
(not really sure if Lastnonblank will do the work.)
I appreciate any help that you can provide.
Thanks in advance.
