Hi,
the column "Current (A) / © Cum" is correct.
carry the formulas used for each column.
if I select a value from year -month I would get the values accumulated up to that month.
Can you help me? Please
example:
if I select only month of April I would like to see only record
A = Sum ({$<year={"$(=$(current_year))"},month={"<= $(Max_month_select)"}>} qta)
cum(A) = rangesum(,above(cum(A)))
year-month | A | Cum(A) | C | cum© | cum(A)/Cum© |
201004 | 2,00 | 235,00 | 1000 | 3142,7421 | 7,48% |
year-month | A | Cum(A) | C | cum© | cum(A)/Cum© |
| 664,3 | 4185,4005 | 9144,28763 | 6699,037479 | |
201001 | 1,00 | 1,00 | 739,830518 | 739,830518 | 0,14% |
201002 | 21,00 | 22,00 | 800 | 1478,794671 | 1,49% |
201003 | 211,00 | 233,00 | 900 | 2153,570024 | 10,82% |
201004 | 2,00 | 235,00 | 1000 | 3142,742064 | 7,48% |
201005 | 3,00 | 238,00 | 1004,457112 | 4147,199176 | 5,74% |
201006 | 54,00 | 292,00 | 300 | 4687,541176 | 6,23% |
201007 | 51,62 | 343,62 | 500 | 4937,006306 | 6,96% |
201008 | 133,19 | 476,81 | 600 | 5239,500016 | 9,10% |
201009 | 47,55 | 524,35 | 600 | 5688,444903 | 9,22% |
201010 | 23,00 | 547,35 | 900 | 6230,592793 | 8,78% |
201011 | 60,61 | 607,97 | 900 | 6508,860369 | 9,34% |
201012 | 56,33 | 664,30 | 900 | 6699,037479 | 9,92% |