Tool to compare

[aparna0208]

Hi,

I am trying to see if there is any share increase between two quarters (Q3 and Q4) and if so how much was the increase compared to prior quarter. I have attached sample data with three columns. Could someone help me out with the tools to implement the logic. I tried using different formula and filter tool but didn't get the expected output. Thank you in advance.

[Aguisande · Accepted solution]

Hi @aparna0208 

A simple formula ([2 Quarters Ago Asset Shares(Q4)] - [3 Quarters Ago Asset Shares(Q3)] ) should do.

If results are positive, amount increased, if negative, the value decreased

[aparna0208]

Perfect @Aguisande :) This is exactly what I was looking for and it worked. Thank you so much:)