Multiple information columns prior to Time Periods columns

Hi,

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.

Accepted answers

Vinay VaradarajM

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!

vinayvm

All comments

Vinay VaradarajM

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!

vinayvm

M.Kierepka

Hi @kristenr,

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:
https://community.anaplan.com/t5/Anaplan-Platform/Convert-Line-Items-to-Time-Periods/m-p/133270#M34487

kristenr

Thank you Vinay, that works!

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…