Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a graphic.
I set a referenced value e.g. year 2014
then i select year 2013
I sent values to Excel, but see only year 2013.
Is it possible to show also referenced value year 2014?
Thx.
Can you explain more, please
I have a graphic
Vertical numbers
Horizontal weeks
in the graphic you see pro week the value of sales that week for example year 2014.
I set these values as referenced.
Now i want to compare each week with year 2013.
i push button values to excel, i see only year 2013 weekly values
not for referenced week
Hope you understand what i mean?
thx. in advance.
Hi Ama,
Could you please attach your QVW for reference....
Thanks,
Kamal
Hi Ama,
I think this file can be helpful...
Thanks,
Kamal
You won't get the underlying data (in Excel) for those you've set Reference to.
You might want to create 2 expressions, one to calculate sales (by week) for the current year, such that it's based on the current user selection or year(max(Date)).
The second expression could be current (year) selection minus 1. i.e. year(max(Date))-1
S.