SUM

[#1]

I have one table with columns: P_ID, Date, PR_ID, PRI_ID, PRICE

That says the price of a product for a specific day.

Now when I select some months so i get only the days from that month in the table en above te total price that mont.

This is clear I hope.

Now I want a graph that shows me every month the total PRICE so the same as the table but now for every month.

When I select the month 01-2010 in the table I get a total PRICE of 331527,37 and in the graph 3131,60

So there is a BIG difference.

Does somebody know what the problem is?

If you don`t understand my question please tell me.

Kind Regards,

Martijn

[john_duffy]

Hi Martijn.

Can you post a sample application using inline load and highlight the issue.

Thanks.

[suniljain]

In Table or graph . are you Suppressing null at either place ?.

[#4]

This is what I have loaded.

here is the problem. I select the month and I get a different total price

[suniljain]

Martin,

Pls post Application . It will help us to solve this issue. From above screen shot I am not clear about where is problem.