1 of 1 people found this helpful
I have reattached your workbook with two different options. The first, is to simply make the diff calculation continuous. The other is to create your view using a couple other calculated fields. Hope this helps!
Nice and simple Tracy - like it
Thanks for your answers.
I use the diff calculation to sort the data, so the last solution is not helping (unless you can sort by the continuous field - which would be really cool!). Eventually the diff calculation is supposed to be hidden - sorry that I wasn't clear.
I also need to have the total on the right side, so I can't use the first solution.
Thanks again, any more ideas appreciated.
What is diff doing compared to a simple sum() minus sum ()
In reality I use many calculated fields and the one that I currently have to sort by is: