Not applicable
2016-02-23
11:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 -Year | ItemName | ItemNo |
Jan-15 | AAA | 1 |
Jan-15 | BBB | 2 |
Jan-15 | CCC | 3 |
Feb-15 | AAA | 1 |
Feb-15 | BBB | 2 |
Feb-15 | DDD | 4 |
Mar-15 | BBB | 2 |
Mar-15 | DDD | 4 |
Mar-15 | EEE | 5 |
Mar-15 | CCC | 3 |
I want to show in straight table as below
Month-Year | NewlyAddedItems |
Jan-15 | 0 |
Feb-15 | 1 |
Mar-15 | 2 |
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
437 Views
2 Replies
Chanty4u
MVP
2016-02-24
02:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
may be lik ids?
Not applicable
2016-02-24
09:38 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
366 Views