Accumulate quarters - stacked charts

[Anonymous]

Hi Guys

I want to accumulate everything in sales, say last 8 quarters, but in the chart I only want to show the last four and stacked together showing Product A and Product B.

I have Date field in Month, Year, QuarterYear

Regards

[miguelbraga]

Can you please add some sample data so we can provide you a solution for your needs?

Regards,

MB

[Anonymous]

This is the dummy data, the calendar is actually auto generated in the script

Date	Product	Sales	Date	Month	Year	Quarter	QuarterYear
01/01/2014	Product A	£    20.00	01/01/2014	1	2014	Q1	Q1-2014
01/01/2014	Product B	£    30.00	01/02/2014	2	2014	Q1	Q1-2014
01/02/2014	Product A	£    40.00	01/03/2014	3	2014	Q1	Q1-2014
01/02/2014	Product B	£    50.00	01/04/2014	4	2014	Q2	Q2-2014
01/03/2014	Product A	£    60.00	01/05/2014	5	2014	Q2	Q2-2014
01/03/2014	Product B	£    70.00	01/06/2014	6	2014	Q2	Q2-2014
01/04/2014	Product A	£    80.00	01/07/2014	7	2014	Q3	Q3-2014
01/04/2014	Product B	£    90.00	01/08/2014	8	2014	Q3	Q3-2014
01/05/2014	Product A	£  100.00	01/09/2014	9	2014	Q3	Q3-2014
01/05/2014	Product B	£  110.00	01/10/2014	10	2014	Q4	Q4-2014
01/06/2014	Product A	£  120.00	01/11/2014	11	2014	Q4	Q4-2014
01/06/2014	Product B	£  130.00	01/12/2014	12	2014	Q4	Q4-2014
01/07/2014	Product A	£  140.00	01/01/2015	1	2015	Q1	Q1-2014
01/07/2014	Product B	£  150.00	01/02/2015	2	2015	Q1	Q1-2014
01/08/2014	Product A	£  160.00	01/03/2015	3	2015	Q1	Q1-2014
01/08/2014	Product B	£  170.00	01/04/2015	4	2015	Q2	Q2-2014
01/09/2014	Product A	£  180.00	01/05/2015	5	2015	Q2	Q2-2014
01/09/2014	Product B	£  190.00	01/06/2015	6	2015	Q2	Q2-2014
01/10/2014	Product A	£  200.00
01/10/2014	Product B	£  210.00
01/11/2014	Product A	£  220.00
01/11/2014	Product B	£  230.00
01/12/2014	Product A	£  240.00
01/12/2014	Product B	£  250.00
01/01/2015	Product A	£  260.00
01/01/2015	Product B	£  270.00
01/02/2015	Product A	£  280.00
01/02/2015	Product B	£  290.00
01/03/2015	Product A	£  300.00
01/03/2015	Product B	£  310.00
01/04/2015	Product A	£  320.00
01/04/2015	Product B	£  330.00
01/05/2015	Product A	£  340.00
01/05/2015	Product B	£  350.00
01/06/2015	Product A	£  360.00
01/06/2015	Product B	£  370.00

[Anonymous]

How do I attach an excel file, haven't been on here for a while.

[miguelbraga]

Go to the Advanced Editor. Through there you can attach files

I'll analyse your problem further.

Just two questions:

Why do you have two fields with the same name?

What those date fields represent?

Regards,

MB

[Anonymous]

That's showing them as two separate tables and the Date field is whats linking them.

[Anonymous]

The Excel data.

[miguelbraga]

What about this?

Regards,

MB

[Anonymous]

No I'm afraid that's even easy for me lol.  I need this and then only show the last three quarters not all four.

Q2	Q3	Q4

	Q1	Q2	Q3	Q4

[miguelbraga]

Check out this solution

Regards,

MB