Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created a report. But when I select the Quarter2 it should show Q1 and Q2 data.
Quarter3 it should show Q1 ,Q2 and Q3 data.
Quarter4 it should show Q1 ,Q2 ,Q3,Q4 data.
Please help.
Thanks in advance.
Hi,
Try like this
=Sum({<Year=, Quarter=, Month=,BillingDate={'>=$(=vStartDate)<=$(=vMaxDate)'}>} Sales)
WHERE
vStartDate = YearStart(Max(BillingDate))
vMaxDate = Date(Max(BillingDate))
Hope this helps you.
Regards,
Jagan.
Remove quarter from your dimension and add in your expression the condition (with set analysis)
{$ <Quarter = {'<=GetFieldSelections(quarter)'}>}
let me know
=aggr(Sum({<Year=,Quarter={"<=$(=vMaxQtr)"}>} Sal),EmpNo)
Hi Alexandros17 ,
Kindly provide the app.
Hi maxgro,
I used that formula. But it is showing only selected Quarter. But I want to show Qn consequently (Qn-1,Qn-2,..) for the selection of Qn.
Kindly provide the app.
Thanks in advance.
I've just replaced your expression in your chart under problem with
=aggr(Sum({<Year=,Quarter={"<=$(=vMaxQtr)"}>} Sal),EmpNo)
and this is the result
Hi Massimo Grossi,
I can see only Quarter 4. But I need to show Q1,Q2,Q3,Q4 in the report as we have selected Q4.
Please provide the app.
Like This:
I think a simple solution could be: 4 expression (as quarters are 4)
=aggr(Sum({<Quarter={1}>} Sal),EmpNo)
...
...
=aggr(Sum({<Quarter={1,2,3,4}>} Sal),EmpNo)
conditional show
for first expression max(Quarter)>=1
....
....
4th max(Quarter)>=4
Here it is
Hi,
Try like this
=Sum({<Year=, Quarter=, Month=,BillingDate={'>=$(=vStartDate)<=$(=vMaxDate)'}>} Sales)
WHERE
vStartDate = YearStart(Max(BillingDate))
vMaxDate = Date(Max(BillingDate))
Hope this helps you.
Regards,
Jagan.