Sum and Max

[Prabhu1204]

Hi

I have a Date Filed, Actual field ,Target field

In the UI I have a date picker , On selecting the dates.. say for example jan to march. I need to sum the values between maximum values of each month.

maximum of jan month + max of feb + max of march.

How to do it in load script

[Taoufiq_Zarra · Accepted solution]

@Prabhu1204  can you share a sample data and the expected output ?

[Taoufiq_Zarra]

@Prabhu1204  for example you can create in load script :

data:
load *,Month(Date) as MonthTmp; 
LOAD Date(Date) as Date, 
     Actual
FROM
[C:\Users\admin\Downloads\sample input.xlsx]
(ooxml, embedded labels, table is Sheet1);



load MonthTmp,FirstSortedValue(Actual,-Date) as Value2 resident data group by MonthTmp;

and then for the output use :

sum(Value2)

output:

for jan to feb

until march:

[Prabhu1204]

Its not working for me.. Not sure what i am doing working. One for march i am getting the value