Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using a cyclic group as a dimension in chart with 'Month,week and days' as sub dimensions.
Now i need to limit the dimensions as follows,
1. Months - for last 3 months
2. Weeks - to last 8 weeks
3. Days - as last 14 days
Irrespective of the from date and to date selected in the calender prompt.
Please guide
Try using expression in group like:
hi Tresesco,
Thanks for your reply.
But I need to limit the week, days and month for the selected dates in the calender prompt
for eg: if from date is : 1st Apr and end date : 30- Apr,
then i need to display last 3 months: Jan,Feb and Mar
last 8 weeks: week 10 - week 18
last 14 days: 15th Apr - 29th Apr
Could you post your sample qvw?
sorry i dont have a sample right now.
If possible provide some sample data in the excel file.