Can I amortise revenue / cost by month in Query Table

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



      • Sticky Posts

      • Announcing Zoho Analytics 6.0 Beta!

        We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team

      • What's New in Zoho Analytics - August 2024

        Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data

      • We are coming to your city! Zoho Analytics Community Meetup

        Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructing

      • Zoho Analytics: 2021 Look Back

        As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021

      • [Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022

        Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution.  Hear more from Claudio Cabeza, Director at PREMO