How can I isolate database entries (since Jaspersoft sums up entries with the same name for charts)

[finn.hoffmeister]

Hey. :-)

My database contains a column "month" (with is the first letter of each month only) and the matching value.

Since there are several letters like "J" for january, june and july or "M" for March and May with multiple values, I have the problem that Jaspersoft is summerizing them.

Is there any way I can seperate them? Do I have to change the query?

Thanks in advance!

[carlos2015]

The big question is: How do you know when "J" is for January or June?

 

[finn.hoffmeister]

There are a lot of additional columns like one for the date (DD.MM.YYYY) and number of month. So I was already trying to do an "ORDER BY" query, but it would still sum up the J´s.