It is to show maximum and minimum values and also in between are deviations from previous values.
I had 3 expressions for max , min and deviation expressions. How can I get out of max value and minimum deviation values showing?
expression for Deviation:
sum({<[Calendar Date]={">=$(=min([Calendar Date]))<=$(=max([Calendar Date]))"}>}Value) - rangesum(below(sum({<[Calendar Date]={">=$(=min([Calendar Date]))<=$(=max([Calendar Date]))"}>}Value),-1,1)))
