Pivot table problem

[#1]

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.

[Oleg_Troyansky]

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

[spividori · Accepted solution]

Hi.

See the attachment. Hope this helps.

Regards.

[#4]

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.

[spividori]

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.