data of currentyear and last year in single graph

[#1]

hi.

i want to show data of current year and last year in a single graph

i'm using this expression.

sum(sale)*688.23/100000000+sum(sale2)*688.34*10000

[ashfaq_haseeb]

try below

Current Year:

sum({$<Year={$(=Only(Year))}>}sale)*688.23/100000000+sum({$<Year={$(=Only(Year))}>}sale2)*688.34*10000

Previous Year:

sum({$<Year={$(=Only(Year)-1)}>}sale)*688.23/100000000+sum({$<Year={$(=Only(Year)-1)}>}sale2)*688.34*10000

Regards

ASHFAQ

[#3]

not working?

anything  else???

[ashfaq_haseeb]

post you sample app.

Regards

ASHFAQ

[ashfaq_haseeb]

Try below

Current Year:

(sum({$<Year={$(=max(Year))}>}sale)*688.23/100000000)+(sum({$<Year={$(=Only(Year))}>}sale2)*688.34*10000)

Previous Year:

(sum({$<Year={$(=max(Year)-1)}>}sale)*688.23/100000000)+(sum({$<Year={$(=max(Year)-1)}>}sale2)*688.34*10000)

Note: Make sure you have [Year] field available.

Regards

ASHFAQ