Full Accumulation in Mini Chart (line)

[#1]

I am trying to create a mini chart in a table that will show the accumulated sales by week but when I use sum of sales as my expression and select full accumulation, it still appears to only show the daily sales, not accumulated sales.

[#2]

Hi dcpy,

Could you attach a small data example?

Best regards.

[#3]

Work Day #	Fiscal year and quarter	above(sum( [Total Booked ($)] ), 0, [Work Day #]) /[Work Day #]
1	2009 Q4	732,571
1	2010 Q1	752,078
1	2010 Q2	1,350,836
1	2010 Q3	909,307
1	2010 Q4	831,157
2	2009 Q4	1,187,021
2	2010 Q1	1,106,800
2	2010 Q2	1,577,258
2	2010 Q3	1,275,548
2	2010 Q4	1,376,825
3	2009 Q4	1,481,307
3	2010 Q1	1,307,216
3	2010 Q2	1,831,235
3	2010 Q3	1,389,513
3	2010 Q4	1,711,848
4	2009 Q4	1,627,820
4	2010 Q1	1,441,064
4	2010 Q2	1,950,801
4	2010 Q3	1,636,054
4	2010 Q4	1,839,681
5	2009 Q4	1,760,902
5	2010 Q1	1,572,143
5	2010 Q2	2,036,607
5	2010 Q3	1,805,440
5	2010 Q4	2,009,137
6	2009 Q4	1,906,124
6	2010 Q1	1,628,362
6	2010 Q2	2,127,284
6	2010 Q3	1,950,852
6	2010 Q4	2,089,018
7	2009 Q4	1,994,106
7	2010 Q1	1,704,067
7	2010 Q2	2,178,931
7	2010 Q3	2,042,173

not sure how to attach data file, will this work

[#4]

this may work better, daily sales, not accumulated by day

Work Day #	Fiscal year and quarter	test1
1	2009 Q4	732,571
1	2010 Q1	752,078
1	2010 Q2	1,350,836
1	2010 Q3	909,307
1	2010 Q4	831,157
2	2009 Q4	454,450
2	2010 Q1	809,172
2	2010 Q2	581,144
2	2010 Q3	592,663
2	2010 Q4	911,909
3	2009 Q4	294,286
3	2010 Q1	494,702
3	2010 Q2	748,679
3	2010 Q3	568,358
3	2010 Q4	702,965
4	2009 Q4	146,513
4	2010 Q1	280,361
4	2010 Q2	399,928
4	2010 Q3	646,468
4	2010 Q4	627,789
5	2009 Q4	133,082
5	2010 Q1	264,161
5	2010 Q2	349,967
5	2010 Q3	519,353
5	2010 Q4	688,808
6	2009 Q4	145,223
6	2010 Q1	201,441
6	2010 Q2	292,118
6	2010 Q3	437,530
6	2010 Q4	517,411
7	2009 Q4	87,981
7	2010 Q1	163,687
7	2010 Q2	215,334
7	2010 Q3	306,655
7	2010 Q4	421,937
8	2009 Q4	63,008
8	2010 Q1	130,405
8	2010 Q2	219,438
8	2010 Q3	283,279
8	2010 Q4	449,330
9	2009 Q4	64,143
9	2010 Q1	118,994
9	2010 Q2	186,628
9	2010 Q3	271,540
9	2010 Q4	336,252
10	2009 Q4	117,233
10	2010 Q1	192,983
10	2010 Q2	246,074
10	2010 Q3	308,382
10	2010 Q4	367,848
11	2009 Q4	51,365
11	2010 Q1	71,332
11	2010 Q2	128,039
11	2010 Q3	185,355
11	2010 Q4	245,802
12	2009 Q4	43,585
12	2010 Q1	87,096
12	2010 Q2	118,556
12	2010 Q3	177,659
12	2010 Q4	249,817