Previous dimension

[#1]

Hello, Everybody!

I have an Issue:

	Mai
Volume (lb)	5000
Price ($)	150,00
Volume  April (lb)	??

I want to show the previous month's volume, I've already tried with Range Sum, but once I make a filter by month (same dimension of this chart), do you guys know how to do that?

Grateful, Luiz Bisco

[sunny_talwar]

Try with Above() function.

[#3]

It doesn't works or I did it wrong!

[sunny_talwar]

Would you be able to share a sample?

[#5]

No, I can't share, I am in company. But here is the thing: I have a filter with monthname of arrival date and my chart has that same dimension.

But I want to show what happens in the previously either, do you know how can I do that?

[sunny_talwar · Accepted solution]

Try this:

Above(Sum({<MonthField>}Sales)) * Avg(1)

Assumptions

1) Your expression was Sum(Sales)

2) Dimension is MonthField where you plan to make selections

[#7]

Sunny, I want to select May and show April (one of expressions will show april, the others will show may)

[sunny_talwar]

Right, this is what it should do. Would you be able to provide few rows of dummy data to demonstrate how this can work?