Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
what is the dimension?
better post a sample qvw file here
my dimension is the day(date)
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?
I cant post an sample sorry
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
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
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