How to display only a range of data in a straight table

[#1]

Hello,

I want to display only a range of data in a straight table.

For example I have data from 01/09/2010 to 31/01/2011 and I want to display only data from 01/10/2010 to 30/01/2011.

Please help.

[SunilChauhan]

sum({<date={">=$(MonthStart(Date))<=$(Monthend(Date))"}>})

hope this heelp

[its_anandrjs]

Hi,

You want to display only this dates 01/10/2010 to 30/01/2011 and the difference of two months.

Regards

Anand

[#4]

Hello,

Sorry for late reply first.

Let me explain the problem.

I have a cyclic group with Month, week name and day.

This group is used as dimension in my straight table.

How can i limit the number of days in this case?

I have data from 01/09/2010 to 31/01/2011 and i want to display data from 01/10/2010 to 31/01/2011

[perumal_41]

Hi

Plase try this expresion .

sum({<date={">=01/10/2010<=31/01/2011"}>} field) .hope this help

Regards,

Perumal.A

[kaushiknsolanki · Accepted solution]

Hi,

     Have a look at the attached sample file.

     Hope it will colve your problem.

Regards,

Kaushik Solanki

[#7]

Thanks for your help.

It worked