Sum for previous year

[gautik92]

I have Chart whic am using to compare current year and previous year

my requirement is like if i select some dates in calendar it should show sum for cy and py

for cy it is working fine

am confused with previous year calculation

i should show sum of previous year for those selected dates

[Anil_Babu_Samineni]

Share me one example please

[sunny_talwar]

Look into As Of Table: The As-Of Table

[Anonymous]

Hi,

Perhaps something like:

For Current year: =Sum({$<Year={$(=Max(Year))}>}Sales)

For last Year:-=  =Sum({$<Year={$(=Max(Year)-1)}>}Sales)

or alternatively, you can look at this: How to create year to year comparison bar chart?

[gautik92]

this is to get previous year

but my requirement is lik if i select some dates in calendar i should get sum for same dates in previous year