Can I amortise revenue / cost by month in Query Table
Hello,
I conduct revenue and cost comparison usually in excel. I would like to know if I can achieve the following transformation within zoho analytics query table:
From this table:
++++++++++++++++++++++++++++++++
Item MRR Start Month End Month
--------------------------------------------------
A 80 Mar-2022 Aug-2022
B 50 Jan-2022 Jun-2022
C 60 Feb-2022 Aug-2022
++++++++++++++++++++++++++++++++
To this table
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Item Jan-2022 Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022 Jul-2022 Aug-2022
A 80 80 80 80 80 80
B 50 50 50 50 50 50
C 60 60 60 60 60 60 60
----------------------------------------------------------------------------------------------------------------------------------
Sum 50 110 190 190 190 190 140 140