Multiple information columns prior to Time Periods columns
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.
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:
Hope this helps!
Generally the best option is to use two grids and synchronized scroll (like @Vinay VaradarajM already explained), but sometimes you can't/don't want to do that (mostly for big smaller grids or for worksheets). Then, if you don't need to input values into non-time based columns, I suggest using the trick I explained in some older post:
Thank you Vinay, that works!1