Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
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