Summing of consecutive rows to find quarterly data from mothly data

[gurujo]

Hi,

I woud like to know how i can find quarterly sums  from monthly data of different Years. using muti row formula tool.

[atcodedog05 · Accepted solution]

Hi @gurujo ,

Here is a workflow for the task.

Input : file provided by you.

Output : 

Hope this was what you were looking for

Workflow :

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind😀👍

[jdunkerley79]

If you want to do this using the MultiRow formula:

IIF(LEFT([Row-1:Year-Month],4)=LEFY([Year-Month],4)
    AND Ceil(ToNumber(RIGHT([Row-1:Year-Month],2))/3)
      = Ceil(ToNumber(RIGHT([Year-Month],2))/3),
  [Row-1:QuarterSum],
  0)
+ [Sum_Value]

This will reset every quarter but assumes the data is in ascending order so you may need a sort before it.

Sample attached

Hope it helps

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀