Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a field period,that field contains
Period | sales |
---|---|
9/29/2015 | 100 |
9/30/2015 | 200 |
10/01/2015 | 333 |
10/02/2015 | 444 |
10/03/2015 | 555 |
10/04/2015 | 666 |
10/05/2015 | 2222 |
Ex:
if i select 10/05/2015 i want data in bar up to latest month dates like 10/01/2015,10/02/2015,10/03/2015,10/04/2015,10/05/2015
if i select 10/02/2015 i want only 10/01/2015,10/02/2015
if i select 10/01/2015 i want only 10/01/2015 bar.
how to achieve this ?
Thanks
Koti
Yesterday you were having same thread??
This was working fine, try it out:
VMaxPeriod=date(max(Period),'DD/MMM/YYYY')
=sum({<Period={'<=$(=VMaxPeriod)'}>}Sales)
You can assign a variable and use it like. Well like there be a variable
vSelectedDate= getFieldselected(Period) -------- this will be in date format and will contain the selected period.
Now use dimesion limit in your bar chart and set values less than.vSelectedDate
But req is different from yesterday
here exp should find current month and dimension values in the chart should current selection month dates only.
For me, what you have mentioned is same what you did yesterday.
NP, try as earlier shared with you:
VMaxPeriod=date(max(Period),'DD/MMM/YYYY')
=sum({<Period={'<=$(=VMaxPeriod)'}>}Sales)
thanks for response balraj ,
but its not working properly
i need only current selection month dates in bar chart
ex : if i select 10/5/2015
i want onlt dates from 10/01/2015 to 10/05/2015.
2) if i select 10/03/2015
i want only dates from 10/01/2015 to 10/03/2015
3) if i select 10/01/2015
i want only 10/01/2015.
Its giving me same output.
PFA..