Graph and Sum quantites per month

[#1]

Hi,

I have a little problem.

I have datas like that :

Item	Date	Quantity
A	01/03/2016	2
B	01/03/2016	1
A	01/03/2016	5
C	05/03/2016	3
A	10/03/2016	4

In my graph I want to show the quantites per month.

I have a master calendar.

And, for example, in my graph I want theses values (for March month) :

A = 11

B = 1

C = 3

I can't explain why, but I can't do that...

In dimension I have "Month" field.

In Expression I have : =Quantity

I tried : Sum(Quantity) but with that I get the total sum and I just want the sum per month.

Could you help me?

Thanx for helping me.

[Kushal_Chawda]

Make sure that Your calendar is linked on Date field and Date Field is in proper date format. Then what you are doing is should work.

Dimension - Month, Item

Expression- Sum(Quantity)

or

Dimension: Month(Date),Item

Expression : Sum(Quantity)

[avinashelite]

Try like this

1.Add Month & Item as the dimensions and 

2.add sum(quantity) as expression

this shoudl  give you the result

[Gysbert_Wassenaar]

Use Month and Item as dimensions and sum(Quantity) as expression.

[#5]

Hi,

The approach is correct, however the something is going wrong with Date field.

It might be where you have segregated the Month from the date field or association of the Fields in your Data Model.

Hope it helps.

Cheers !

[jagan]

Hi,

Derive a month in script like below

Data:

LOAD

*

MonthName(DateFieldName) AS Month

FROM DataSource;

Now try like below in chart:

Dimension: Month, Item

Expression: Sum(Quantity)

Hope this helps you.

Regards,
Jagan.

[Chanty4u]

chk dis

[Chanty4u]

sry

[ahmar811]

hi

Beaulieu Mathieu

try attached sample file.hope this help you

Thanks & Regards

Ahmar Ansari