Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Newly Added records based on Month

Hi All,

I have a requirement where I want  to  count the number of items that are  newly added . I need to compare the items with that of previous Month

Month -YearItemNameItemNo
Jan-15AAA1
Jan-15BBB2
Jan-15CCC3
Feb-15AAA1
Feb-15BBB2
Feb-15DDD4
Mar-15BBB2
Mar-15DDD4
Mar-15EEE5
Mar-15CCC3

I want to show in straight table as below

 

Month-YearNewlyAddedItems
Jan-150
Feb-151
Mar-152

I need to do this in Chart level without changing in the script. How this could be done in chart?

Help on this ..

Thanks,

Kavya

2 Replies
Chanty4u
MVP
MVP

Not applicable
Author

i want to display like this in the above example

NewlyAddedItems will be defined as any ItemNo which is a ItemNo in the current month and not a ItemNo on the previous month