Show Precedent Line Items


Excel has a great feature that shows dependent and precedent cells for formulae. For those that do not know, here is a screenshot of trace precedents in action:

Trace Precedents.png

The blue arrow is indicating that Profit is dependent on Costs and Revenue. This is a great visual way to show how cells affect one another.

Whilst Anaplan has Drill Down, which is a great feature, I think another extremely useful feature would be Show Precedent Line Items.

How this would work:

  1. User right clicks on a line item and selects Show Precedent Line Items
  2. Anaplan will show the selected line item, and all line items (within the module only) that are precedent to the line item formula.

Using the excel example, if we had a module that had RevenueCosts, and Profit line items; selecting Show Precedent Line Items on Profit would show ProfitCosts, and Revenue.

This would be incredibly helpful in larger modules where there are many line items. Additionally, where Drill Down limits your view typically to single list items, there's no reason why this could not be applied at a summary level.

5 votes

New · Last Updated


  • Miran
    Status changed to: New
  • And building on that .. in blueprint view to show where a line item has come from so a referenced from if you will, particularly helpful where a line item formula can be long

  • We need this functionality to show all the dependent formulas across all modules in the application so we will know the potential impact when you have to parachutte into an app to support it and are not sure what all your change could break downstream.

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!