Current Year Problem

[Anil_Babu_Samineni]

Hi,

I have data like 2009 - 2012

I want to display only 2012 Data using Set Analysis

For Reference, PFA

[sunny_talwar]

May be this Anil:

Sum({$<[Year Order Date] = {$(=Max([Year Order Date]))}>} Sales)

[MindaugasBacius]

Sum({$<[Year Order Date] = {"$(=max([Year Order Date]))"}>} Sales)

Try like this.

[Anil_Babu_Samineni]

Yes, So after that i want to show Last year.

And how to get the data for Max Year Vs Max Year-1

Meantime, I want to show that Difference in Line

Please help me...

[sunny_talwar]

What do you mean a line? How would you want to see a line here?

[Anil_Babu_Samineni]

Yes,

So here i want to know change of 2012 & 2011 ( I want to show that difference in line Chart) with these two graphs..

- Anil

[sunny_talwar]

But difference between two numbers is a single number... How do you expect to see a line?

[Anil_Babu_Samineni]

So, I Apologize that.

I want to know difference Value. How do i get that in Chart, Please?

- Anil

[sunny_talwar · Accepted solution]

Are you may be looking for something like this...

[Anil_Babu_Samineni]

Yes, It's similar to that.

Here

Sum(Sales) -- Sum({$<[Year Order Date] = {$(=max([Year Order Date]))}>} Sales)

Above(Sum(Sales)) -- Sum({$<[Year Order Date] = {$(=max([Year Order Date])-1)}>} Sales)

Final Expecting is -- Sum({$<[Year Order Date] = {$(=max([Year Order Date])-1)}>} Sales) - Sum({$<[Year Order Date] = {$(=max([Year Order Date]))}>} Sales)