Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
i want based on date field only, i don't want month field
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
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
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.