Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
please check attached images, why February is missing in above statement?
Can you share your complete sum() expression with Above()
Are you using like Above(Sum(Sales), 0, RowNo()) ?
Can you please let us know what's your complete Above() expression?
Because, You are calculating with Previous one to previous one. Sum(Sales) - Above(...) will return correct only but not the starting stage or sequance
Simple answer to your question is that, February doesn't show because the data isn't sorted in the right sort order. If the sort was done correctly, then January would not have shown. Is that something you want or do you even want to see January for 2014 and 2015? (2013 won't show because you don't have 2012 data)...but for 2014, you can try your above function with a total
Above(TOTAL Sum(....))