compare date this year with date last year

[#1]

hi,

I'm trying to to compare two dates. for example 2012-08-01 with the thursday last year it was 2012-08-03. But in the pivottable the two dates are not shown next to each other how can I solve this problem?

regards,

MT

[#2]

what is the dimension?

better post a sample qvw file here

[#3]

my dimension is the day(date)

[#4]

you need to post a sample becouse there are many ways to do that depending on the sheet objects, data structure, selection etc

could you?

[#5]

I cant post an sample sorry

[#6]

i'm sure you can preper a small example with one chart and random data (using inline script)

i just want to know where you want to compare those two values - so i need to know how does your chart look like

[#7]

ok what I want now is that my chart looks like that

31      Mi      01.08.2012     03.08.2011     profit2012     profit2011

is that possible??

one way of thinking was to use date insteat of a dimension as an expression

[#8]

sorry for late answer;)

try to use only day and week  as a dimension and use set analysis in teh expression (plus add calendar table)

see attached file