Dear all,
I have a table with a range sum:
Dimension: =day([Reporting Date])
Measurement:
rangesum(above(
(((Sum({<[Reporting Month]={'$(=(Prior_Month_YYYYMM -1))'},[Cash Code]={'APP'}>}[Cash Amt])
+ Sum({<[Reporting Month]={'$(Prior_Month_YYYYMM)'},[Cash Code]={'APP'}>}[Cash Amt]))
/
(Sum({<[Reporting Month]={'$(=(Prior_Month_YYYYMM -1))','$(Prior_Month_YYYYMM)',[Type]={'INV'},>}total <[Reporting Month]>[Trans USD])))
*Sum({<[Reporting Month]={'$(=(Current_Month_YYYYMM))'},[Type]={'INV'}>}total <[Reporting Month]>[Trans USD]))
,0,RowNo()))
Giving me this result:
| FC cash per day | Forecast Cumulative |
1 | | 639,882.48 |
2 | | 885,020.12 |
3 | | 1,187,061.15 |
4 | | 1,382,114.03 |
5 | | 1,735,847.19 |
6 | | 2,094,285.78 |
7 | | 2,431,650.56 |
8 | | 2,725,305.94 |
9 | | 3,187,825.26 |
10 | | 3,632,806.18 |
11 | | 4,139,802.24 |
12 | | 4,684,970.65 |
13 | | 5,225,358.19 |
14 | | 5,681,546.00 |
15 | | 6,456,909.45 |
16 | | 7,409,575.81 |
17 | | 8,452,425.93 |
18 | | 9,294,316.51 |
19 | | 21,203,113.07 |
20 | | 22,492,789.38 |
21 | | 23,753,828.93 |
22 | | 25,026,962.65 |
23 | | 25,843,415.87 |
24 | | 26,555,677.48 |
25 | | 26,891,303.66 |
26 | | 27,723,293.21 |
27 | | 28,026,015.42 |
28 | | 28,300,626.72 |
29 | | 28,654,664.12 |
30 | | 28,998,827.41 |
31 | | 29,303,295.16 |
What I want is that it shows me the day, for an example I only want to see the data, if imagine the day is the 21st of month, till day 21.
The table should show me the following result:
| FC cash per day | Forecast Cumulative |
1 | | 639,882.48 |
2 | | 885,020.12 |
3 | | 1,187,061.15 |
4 | | 1,382,114.03 |
5 | | 1,735,847.19 |
6 | | 2,094,285.78 |
7 | | 2,431,650.56 |
8 | | 2,725,305.94 |
9 | | 3,187,825.26 |
10 | | 3,632,806.18 |
11 | | 4,139,802.24 |
12 | | 4,684,970.65 |
13 | | 5,225,358.19 |
14 | | 5,681,546.00 |
15 | | 6,456,909.45 |
16 | | 7,409,575.81 |
17 | | 8,452,425.93 |
18 | | 9,294,316.51 |
19 | | 21,203,113.07 |
20 | | 22,492,789.38 |
21 | | 23,753,828.93 |
Can you please help me getting this done? Thanks
