
1. Re: Create row level calculation using previous value
Norbert Maijoor Dec 29, 2018 12:21 PM (in response to jon rios)Hi Jon,
Not sure if I understand your challenge but find my approach as reference below and stored in attached workbook version 10.5 located in the original thread.
1. M1. Lookup: lookup(min([Value]),1)
2. M2. 1 or 0: if sum([Value]) >= [M1. Lookup] then 1 else 0 end
3. Drag the required objects to the indicated locations and show filter
Hope it helps,
Regards,
Norbert

lookup nalmai v10.5.twbx 33.2 KB


2. Re: Create row level calculation using previous value
jon rios Dec 29, 2018 1:57 PM (in response to Norbert Maijoor)thanks Norbert, i did the same calculations in my example in my first post...
if you look at the data source tab, you will see there is not a row level calculation , because of the table calculation (LOOKUP) it is an aggregate...
i want a row level calculation not an aggregation... is there anyway to write this as a row level calculation and not as an aggregate (table calc)?