Refer previous date value using below()

[#1]

I have to refer to a previous date value. I have an expression which gives me Maxdate value month wise. I need to calculate the previous day value in the next column. That is, I need something like : Below( Previous calculated column). But it is not working. Any help is appreciated. I am using a straright table.

Thanks.

[#2]

I will explain a bit more,

Month	Date	Closing	Pre Closing
Jan	10-01-2013	11	22
Jan	09-01-2013	22	30
Jan	07-01-2013	30	4
Jan	01-01-2013	4

Closing is a calculated column and I want Pre Closing. Tried Below(Closing) in vain. Can somebody help please?

[sparur]

It should work.

try to use expression like this:

below(sum(Value))

where sum(Value) is Closing expression.

or could you provide qvw example?

[#4]

Thanks Anatoly for your reply.

PFA

While i select multiple company values, it works, but i would have one company selected in real scenario.

[sparur]

What do you mean?

[#6]

In the attached file, if you select multiple companies, you would find some values being populated in the Pre Closing column, but none when one company is selected.

[sparur · Accepted solution]

in this case, use Below(TOTAL CurrentClose)

[#8]

Thanks. May I request you to look into the requirement 2 in the attachment? It would be very nice of you.

[sparur]

as I understand, you need show only 5 max Open Interest values...

the simple way is change chart type to straight table and use Dimension limits.

Is it Ok for you?

[#10]

That is a constraint, I have to use pivot. Please suggest a way. Basically, i have multiple transactions against each date and i have to show top 5 of them against each date,company....