Forum Discussion
Rank by process and date selection
Hi, I really hope someone can help me out with this problem. I need to rank values by their inconsistent process names over a date range selection, as shown in the illustration below. The pro...
CahabaDatav-sihou-msft, thank you both for your replies. Both your suggestions work, but I should also have mentioned that this was just the first step. Once I found a way to rank processes by date range, I need to be able to offset their totals and subtract the latest from the previous, which I haven't been able to do yet.
Any suggestions?
as words are subject to interpretation (for instance I don't understand what is meant by "offset"...) - I suggest you provide 2 sets of data
i.e.
1. Have this
2. Need this
and if the aggregation is not obvious to us - a brief explanation of what the aggregation logic is....
You already have posted 3 data sets - and so it is not clear as to what would now be your starting point for the next step....