Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
i need to show last 3 months and since launch data based on filter, and the dimension should be max weekend to 12 weekends each weekend to display last 3 months as well as since launch based on filter.
please help me i am adding qvw as well as target screen shot.
Use expression
if(dim='Since Launch',sum(IUP),sum({<Date={">=$(=AddMonth(today(),-3))"}>}IUP))
see attached
I believe this is the right expression
If(dim = 'Since Launch', Sum(IUP), Sum({<Weekend = {">=$(=AddMonths(Max(Weekend), -3))"}>}IUP))
hi here i need to display max weekend to last 12 weekends also
hi sunny need to show weekends as well please help me