The accumulation occurs within the data source and I will not be able to interrogate into this system further to get to the raw counts.
The Value is the only field I would like to adjust.. I would like to remove the accumulated values and replace with the individual counts by time group?
Sorry if I am not explaining well.
what do you consider to be a time group? are the groups the actual date/time combiantion and you want to know how much occured within each combination isntead of it being cumulative?
1/1/2015 ####### 01/01/2015 11:00:00 5 1/1/2015 ####### 01/01/2015 12:00:00 2
in the snippet above, do you want to accumulate to say there are 5 transaction on 1/1/2015 within the 11:00 hour and there were 2 transactions on 1/1/2015 in the 12:00 hour?
(biff, embedded labels, header is 1 lines, table is Sheet1$);
if(Area=peek(Area) and Date=Peek(Date), Sum - Peek(Sum), Sum) as NewSum
order by Area, TimeStamp;
DROP Table a;
I think the Sum (not cumulated) in row 45 of excel should be 2