Calculating the value for Current Month ARR and Last Month ARR

Question

Dear Team,

Please find the attached sample data.

I would like to calculate values for Current Month ARR and Last Month ARR on the basis of Particular Month, Subsidiary, Segment and Name as well.

Let me know if any further clarifications are required.

Best,
Surbhi

sample data(appended)Sept 22,2022.csv

gyang3 · Answer

Hey @SurbhiMittal it'd be helpful to provide a bit more context as to what you are looking to achieve. Can you provide a screenshot of your initial inputs and desired output?

philipmannering · Answer

Could you clarify what difficulties you are encountering doing this yourself?