[ASK] how to compare current year with last year ?

[#1]

hello..

i have fields : year, sales_total, product_total

and first i made a table like this :

i'm trying to compare current year Sales Revenue with previous year Sales Revenue with a chart

first try i use city as a dimension, and expressions : current year -> if(Year,sum(Sales)) , previous year -> if(Year-1,sum(Sales))

and the result is :

the previous year still show the current year result

is there anyone able to help?

btw i load data from XLS files..

many thx...

🙂

[#2]

if you want to be able to do it only for the Current year ie 2005 and the previous year ie 2004 it's quite easyand there will be no need to select and fields.

Current year = sum ( if ( Year = Max(Year) , Sales,))

Previous Year = sum ( if ( Year = (Max (Year)-1, Sales, ))

In case you want to do it for 2004 & 2003 you will have to deselect all years after 2004