Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
i have the data like this year,quarter and sales.if user select quarter i want to show current year quarter(i.e,Q3 of 2014) and next qaurter of the year(i.e,Q4 of 2014) and if user selects year i want to show previous four quarters total in one bar and future four quarters in one bar
Thanks in advance
Hi,
Attach some sample file.
Regards,
Jagan.
Hi Jagan,
FYI
Hi,
PFA file for solution.
Regards,
Jagan.
Hi Jagan,
Thanxz a lot for your work. your always awesom as usual. but i need to show by default,current quarter should be
based on system calendar (i.e, were in q3 of 2014 and next quarter would be q4 of 2014) and samewith year
Hi,
Try like this
For Current Quarter
=Sum({<Year=, Month, quarter=, Date={'>=$(=QuarterStart(Today()))<=$(=QuarterEnd(Today()))'}>} Amount)
Regards,
Jagan.
Dear Sruti,
Here is the solution. Kindly find attached files (qvw and xls).
Kind regards,
Ishfaque Ahmed