Multiple information columns prior to Time Periods columns

edited December 2022 in Modeling


Asking for some general advice on how best to manage this.

We have several schedules in Excel which show mutliple information columns prior to the Time Period Columns. Eg. 

Project Name | Project Type | Product | Start Date | End Date | Jan 22 | Feb 22 | Mar 22 | Apr 22| etc.....

There are several tables like this that I would then like to have a consolidated report which picks up the total of each of these schedules which all have the line item months in common but not necessarily the other line items (although they do have common dimensions). 

I am struggling to work out the best way to approach this as if I use actual time periods then I cannot show these information columns that the user requires to be able to enter the appropriate forecast amount in the time columns.  

Any advice would be greatly appreciated. 
Thank you. 


Best Answer

  • Vinay VaradarajM
    edited December 2022 Answer ✓

    Hi @kristenr ,


    You might want to create two separate grids and publish them using synchronised scrolling.

    1st grid can hold attributes, while the 2nd one can hold the time phased data. Below is an example for your reference:

    Screenshot 2022-12-23 at 2.32.44 PM.png

    Hope this helps!