Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I hav a pivot table with year as dimension, sum (sales) is my expression. I tried to create a second expressions which shows
the year vs. the current year
Year | Sales | Sales vs. Current year
2009 ....
2010
2011
Is this possible? Before does'nt fullfill my needs.
Thanks for your help.
Kind Regards
I'm not sure quite what you're after. Sales for that year as a percentage of current year, for instance? Something like this?
sum(Sales)/sum({<Year={$(=year(today()))}>} Sales)
Hi John,
I tried your expression but in this case I only get a value if the dimension year is the same as the year(today). I know that the values are excluded by the table dimenstion itself. I'm trying to show the difference between eg. 2009 and the current year (2011) or 2010 and the current year for each customer.
is this possbile?
Thanks for help
Regards
Hi,
I think I've got it.... sum({$<Year = {'2010'}>} total <"CustomerID"> Sales)