hi

[vignesh_s]

I was learning about 'Above' Function ,i worked out with some example but i geting the wrong result,the -ve value is not printing ,can any1 help me to solve ths...

[sunny_talwar · Accepted solution]

You have two dimensions? May be you need Above(TOTAL Units)... but not entirely sure what the goal is...

[vignesh_s]

Thanks its working ,but i have doute tat why we are using total of unit,can u expalin it

[sunny_talwar]

Above() function, without TOTAL, only looks at the above field when your second last dimension is the same... so when you had ProductID and Units as dimension... you only saw a value for Above() when ProductID repeated (ProductID = 3)... Whereas Above(TOTAL) looks above regardless of changing dimensions. If you want to use Above(), you probably need to use just ProductID with Sum(Units) intead of just units

[vignesh_s]

Thank You,it helped me alot