Rangsum of values for each day separately

[kavieweg]

Hi Togehter,

i wolud like to use this working Statement for every day in my data_table. If i pick one day, everything is fine. If I pick more than one day, than i dont want a rangesum over all values of all days.

rangesum( above(SUM({$<[Order Type]={'A'}, [Category]={'COLLECTED'}>} [TOTAL_WEIGHT]),0,rowno()))

Thanks for helping.

Mathias

[mdmukramali]

Hi,

Can you attach sample data file.

[kavieweg]

Datetime / Dimension	Order ID	date	weight in kg	What i want	What i get rangesum
01.03.2018 12:00	A	01.03.2018	20	0	0
01.03.2018 12:30	B	01.03.2018	8	20	20
01.03.2018 12:45	C	01.03.2018	19	28	28
01.03.2018 13:00	D	01.03.2018	27	47	47
02.03.2018 10:00	E	02.03.2018	6	0	74
02.03.2018 11:45	F	02.03.2018	8	6	80
02.03.2018 12:00	G	02.03.2018	21	14	88
..	..	..	…	…

[Anil_Babu_Samineni]

Not Really sure, Your Open question, Perhaps this?

If(GetSelectedCount(Date)>1, SUM({$<[Order Type]={'A'}, [Category]={'COLLECTED'}>} [TOTAL_WEIGHT]), rangesum( above(SUM({$<[Order Type]={'A'}, [Category]={'COLLECTED'}>} [TOTAL_WEIGHT]),0,rowno())))

If This is in Pivot Table, You can try like

Sum(Aggr(If(GetSelectedCount(Date)>1, SUM({$<[Order Type]={'A'}, [Category]={'COLLECTED'}>} [TOTAL_WEIGHT]), rangesum( above(SUM({$<[Order Type]={'A'}, [Category]={'COLLECTED'}>} [TOTAL_WEIGHT]),0,rowno()))), Date, .....)

[sunny_talwar]

May be this

Aggr(RangeSum(Above(Sum({$<[Order Type] = {'A'}, [Category] = {'COLLECTED'}>} [TOTAL_WEIGHT]), 0, RowNo())), date, Datetime))