8 Replies Latest reply: Mar 21, 2016 3:20 AM by Ahmar ansari

# Graph and Sum quantites per month

Hi,

I have a little problem.

I have datas like that :

ItemDateQuantity
A01/03/20162
B01/03/20161
A01/03/20165
C05/03/20163
A10/03/20164

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.

• ###### Re: Graph and Sum quantites per month

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)

• ###### Re: Graph and Sum quantites per month

Try like this

1.Add Month & Item as the dimensions and

this shoudl  give you the result

• ###### Re: Graph and Sum quantites per month

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

• ###### Re: Graph and Sum quantites per month

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 !

• ###### Re: Graph and Sum quantites per month

Hi,

Derive a month in script like below

Data:

*

MonthName(DateFieldName) AS Month

FROM DataSource;

Now try like below in chart:

Dimension: Month, Item

Expression: Sum(Quantity)

Hope this helps you.

Regards,
Jagan.

• ###### Re: Graph and Sum quantites per month

chk dis

• ###### Re: Graph and Sum quantites per month

sry

• ###### Re: Graph and Sum quantites per month

hi

Beaulieu Mathieu