Lost information when using IF statement

[Anonymous]

Hey everyone,

Well, I have some data with the following colums on my database:

TYPE, VALUE, YEAR, MONTH

I am trying to make a bar chart with only one TYPE type.

I am using Sum(if([TYPE]="A", [VALUE]))

It does sum up all VALUEs in TYPE A, but then I lose the Year and Month information on the grap. All the VALUE is displayed in the gray bar.

Can anyone help me out with this?