Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi dcpy,
Could you attach a small data example?
Best regards.
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
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 |