Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there!
I've trying to use pivot table to show information between historical sales, but I use as dimension variable "year" and use dimension "weeks" on columns and expresion sum units sold.
So, I need to show differences per year on same week but I can found the best way but I cant to move this format, so just to use formulas to check this year divided on last year later.
Please give a little help with it.
Thanks a lot.
I attah .qvw file and screen to figured my request.
If you need to show Year over Year difference, I'd suggest not to use Year as a Dimension, but rather use individual expressions with Set Analysis Conditions for each Year:
Expression1: Current Year
Expression2: Prior Year
Expression 3 Change year over year.
cheers,
Oleg
Hi.
See the attachment. Hope this helps.
Regards.
Thanks a lot Sandro!!!!
Can I hide first column? I don't need it.
But second column use the first and answer mi question.
Thanks.
Hi.
Exactly, the second column uses the first, is the way I solved it, I do not know if there will be another way to do it.
Regards.