Show only current months of Current Quarter

[#1]

Hi All,

Can anyone suggest me solution for the below problem,

Calender Date Starts from =November 2013-October 2014

Quarter starts from Nov-Oct.

Q1=Nov-Jan,Q2=Feb-Apr,Q3=May-July,Q4=Aug-Oct.

How to keep a text box,Such that when user clicks on that,

it shows only current Quarter Months(i.e-As of Now(May,June,July) in the bar chart.

I have attached the qvw.

[ashfaq_haseeb]

Hi try below.

=Sum({<Date={'>=$(=QuarterStart(Max(Date)))<=$(=Max(Date))'}>} Sales)

Regards

ASHFAQ

[tresesco]

In a list box:

=Concat(distinct Month(If(InQuarter(Date,Today(),0),Date)), ',')

Update: as your quarter is self defined, try: =Concat(distinct Month(If(InQuarter(Date,Today(),0,2),Date)), ',')

[#4]

Hi Ashfaq,

It is not working.

[#5]

Hi Tresesco,

Can you please tell me where to implement your Calculation?

Am not able to get it in list box

[tresesco]

PFA

[#7]

If i Click on Current quarter text box, data should change for the below bar chart. Bar chart should show sales Data for , June,June end,july,july end, May,May end

[tresesco · Accepted solution]

This? PFA