comparison of current month vs previous year same month data

[Anonymous]

Hi all,

I want to create a straight table for comparison of current month vs previous year same month data as given below:

Month	Claims	Approved Claims
CYTD	10000	2000
PYTD	8000	1000

Any help with this is appreciated.

Thanks in Adavance

Anupama Jagan

P.S.

Attached sample data

The requirement is to get a table like below: For eg : current month is apr so the table should like this

Month	Claims	Approved Claims
Apr 2017	10000	2000
Apr 2016	8000	1000

[MK_QSL]

Provide sample data or app to work..

[ahaahaaha]

Hi,

may be as attached file.

Regards,

Andrey

[Anonymous]

Anupama,

Can you provide sample data?/ And do you want the table should be exactly like above??

[Anonymous]

Hi,

You can create two calendars in your data model.

if you can provide a sample date, it will be easier to help you

[buzzy996]

try tis way,

=sum({$<Year={$(=Max(Year))},Month={"<=$(=max(Month))"}>}Sales)

=sum({$<Year={$(=Max(Year)-1)},Month={"<=$(=Month(Now()))"}>}Sales)

[Anonymous]

Hi Shiva,

Yes this is the requirement. I will attach a sample data soon

[Anonymous]

Hi All ,

I have now attached a sample data in the original post..

Thanks,

Anupama Jagan

[#9]

Hi ,

Month,Month_id

Jan 1

Feb 2

Mar 3

....

Dec 12

Create a Month_id  for the month field and use the following expressions in your straight table

=sum({<Crtd_Year={$(=Max(Crtd_Year)-1)}, Month_id={$(=max(Month_id))}>}Claims)

=sum({<Crtd_Year={$(=Max(Crtd_Year))},Month_id ={$(=max(Month_id))}>}Claims)

Regards,

Balakrishnan.R

[Anonymous]

!I have added one row data in the data source in order to test my result.

Hope the example below will help you.