I'm lost here! I can't follow you completely. Please can you explain in detail? I understand that you wanted the last row but what do you mean by...
Sagar Gupta wrote:
Note: i have 20 different calculated metrices but here i have shown only two(A-B & A/B), so don't ask me to write expressions for Quarters(Q8 to Q7 and Q5-Q1).
Do you want to calculate in Script or Charts?
What i meant by the sentence you highlighted is:
I have fields as A and B, and what you can see here (A-B, A/B) are calculated metrices. So, like A-B and A/B there are 20 others.
Why I am telling you the above things is b'coz i dont want to write expressions 9 times(Q8, Q7....Q1, Q5-Q1) for each calculated metric(A-B).
Now If u r clear with my problem plz let me know the solution. I will be greatfull to you. :-)
I don't think you are writing expression for each row rather you are writing expression based on Fields. So essentially you are writing expression only once. Please can you provide some sample data from your application? I'll mock up an example for you.