0 Replies Latest reply: Feb 11, 2011 12:45 PM by AndreaPeretti

# Select accumulated percentage

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.

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([A],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%