bar chart , returning sum(sales) and reference ID

[thanhphongle]

Hello Community,

I'm not really good at set analysis, but it would be great if anyone can help me out here.

I have a table with

Date	Reference ID	Product	Sales
01.01.15	100001	A	100
01.01.15	100001	A	100
01.01.15	100002	B	200
01.06.15	100003	C	300
01.06.15	100003	A	100
01.09.15	100004	B	200
01.09.15	100004	C	300

The barchart should return me sum(sales) with the reference ID as Quick Information and Values in the graphic by choosing Date as Dimension

Example:

01.01.15 = sum(sales) = 200 with Reference ID 100001

01.01.15 = sum(sales) = 200 with Reference ID 100002

01.06.15 = sum(sales) = 400 with Reference ID 100003

01.09.15 = sum(sales) = 300 with Reference ID 100004

[tresesco]

Do you want two bars for 01.01.15 date?

[miguelbraga]

Greetings,

Check this out:

Hope it helps

Regards,

MB

[miguelbraga]

By the logic of your example:

Example:

01.01.15 = sum(sales) = 200 with Reference ID 100001

01.01.15 = sum(sales) = 200 with Reference ID 100002

01.06.15 = sum(sales) = 400 with Reference ID 100003

01.09.15 = sum(sales) = 300 with Reference ID 100004

Shouldn't the last expression result be 500?

[sunny_talwar]

Looking for this?

Dimension:

=Dual(Date, Date&[Reference ID])

Expression1:

=Sum(Sales)

Expression2:

=[Reference ID]

Expression2 needs following settings on the expression tab

[HirisH_V7 · Accepted solution]

Hi ,

May be like this,

Dimension:

Date

Reference ID

Expression:

=Aggr(Sum(Sales),[Reference ID],Date)

Hope this helps,

HirisH

[miguelbraga]

Missed the part where you want a bar chart, just convert using the screenshots provided:

[thanhphongle]

Thank you to everyone responding on my problem.

It works well with the solution of Hirish and Miguel!