Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear members,
i have a sample data
requirement is if i select any year or month bar graph will show three bars
one bar current month
sec bar prev month
third bar last year curr month values comp sector wise fin calender
for this you have to use aggr function to see the graph comparision between months
for last yr currnt selection
( {$<month = {$(=Only(year)-1)}>} sector)
you can add another expression for last year as by use of variable vlast year so it look like
( {$<month = {$(vLastYear)}>} sector )
for previous month
{$(only(month)-1)}
for current month
{$(only(month))}
hope it helps you....
Hi,
First you have to prepare Master Calendar which consist of year, month n all.
Add dimension as Sector.
Then add this 3 Exp.
Current Month :
=sum({<CalendarYear={$(=max(CalendarYear))},CalendarMonthName={$(=Month(Max(Transaction_Date)))}>} OS_Approval)
Previous Month:
=sum({<CalendarYear={$(=max(CalendarYear))},CalendarMonthName={$(=month(addmonths((max(Transaction_Date)),-1)))}>}OS_Approval)
Last year current month values:
sum ({ <Transaction_Date= P( { <Transaction_Date={">=$(=(Max(Transaction_Date)-365) ) <= {<CalendarYear={$(=max(CalendarYear))},CalendarMonthName={$(=Month(Max(Transaction_Date)))}>}"}>} ) >} OS_Approval)
Hope this will help you.
Regards,
Nirav Bhimani
thanks for replay
and wt is mean by p for last exp
Hi
Try this expressions
For current month selected
=Sum({<Year=, Month=, DateField={'>=$(=MonthStart(Max(DateField)))<=$(=MonthEnd(Max(DateField)))'}>} Sales)
Previous Month
=Sum({<Year=, Month=,DateField={'>=$(=MonthStart(Max(DateField), -1))<=$(=MonthEnd(Max(DateField), -1))'}>} Sales)
Last year current month
=Sum({<Year=, Month=,DateField={'>=$(=MonthStart(Max(DateField), -12))<=$(=MonthEnd(Max(DateField), -12))'}>} Sales)
Hope this helps you.
Regards,
Jagan.
Hi,
P means All possibility.
All the above expression are working hope this will help you.
Ur problem has been resolved?
Regards,
Nirav Bhimani
thanks but last one is not working i have fin cal here
cani send my app
Hi Ram,
Please share your QVW file.
Regards,
Nirav Bhimani
hai
Hi,
Try this.
=Sum({<Transaction_Date={'>=$(=MonthStart(Max(Transaction_Date), -12))<=$(=MonthEnd(Max(Transaction_Date), -12))'}>} Repay)
Hope your problem is resolve.
Regards,
Nirav Bhimani