Which set of statements generates monthly amount on a cumulative basis annually?
A. result = load “opportunity1”; result = group result by (‘CloseDate_Year’,’CloseDate_Month’); result = foreach result generate ‘CloseDate_Year’,’CloseDate_Month’, sum(sum(Amount)) over ([
B. result = load “opportunity1”; result = group result by (‘CloseDate_Year’,’CloseDate_Month’); result = foreach result generate ‘CloseDate_Year’,’CloseDate_Month’, sum(sum(Amount)) over ([
C. result = load “opportunity1”; result = group result by (‘CloseDate_Year’,’CloseDate_Month’); result = foreach result generate ‘CloseDate_Year’,’CloseDate_Month’, sum(sum(Amount)) over ([
D. result = load “opportunity1”; result = group result by (‘CloseDate_Year ~ ~ ~ CloseDate_Month’); result = foreach result generate ‘CloseDate_Year’,’CloseDate_Month’, sum(sum(Amount)) over ([