Issue of date field

[#1]

Dear All.

i have data like jan,feb,mar,apr,may,june,july,Aug.

in that some times i want total data like Jan to Aug-------->this is one expression

second one i want total data like Jan to July only here i don't want Aug month data -------------this is second expressions

Thanks & Advance

Babu

[preminqlik]

helo there,

first expression :
sum({<Month={'Jan','Feb','Mar','apr','May','Jun','jul','Aug'}>}Sales)

Second Expression :

sum({<Month={'Jan','Feb','Mar','apr','May','Jun','jul'}>}Sales)

regards

Premhas

[#3]

i want based on date field only, i don't want month field

[#4]

Can u pls givve the clarification or screen shot

i hope u want the to show the data in list box jan to july u can write expression in list box using match function

in second list box u can write expression for others too

[Anonymous]

Hi Babu,

sum({<Date={">=$(=yearstart(today()))<=$(=makedate(2013,8,31))"}>}Sales)

Second Expression :

sum({<Date={">=$(=yearstart(today()))<=$(=makedate(2013,7,31))"}>}Sales)

Try in this form, hope it will help you

Regards

Nitin

[jagan]

Hi,

If you have a date dimension in your data model then use below expressions

=Sum({<MonthDimensionName=, DateDimensionName={">=$(=YearStart(Today()))<=$(=MakeDate(2013,8,31))"}>}Sales)

Second Expression :

=Sum({<MonthDimensionName=, DateDimensionName={">=$(=YearStart(Today()))<=$(=MakeDate(2013,7,31))"}>}Sales)

Hope this helps you.

Regards,

Jagan.