Return a Line Item Summary

Question

I am certain this is an easy fix and I have only been staring at the computer too long to make sense of it anymore….but, I want to return the summary of a line item as another line item so that the same summary value shows across each of the job levels.

In this example I want 3,042,000 to show up against each of the job levels in the highlighted line item.  Anyone have the quick answer that I know this will be?

rob_marshall · Accepted Answer

@charlotte.chiasson

There are 2 ways of doing this:

* In the Applies To for the line item yellow, remove the Job Levels list from the Applies To and reference the Total line (the one with 3,042,000 amount)
* the 3,042,000 line item (call it Amount), the formula for all of the zeros would be Amount[Select: Job Levels] assuming Job Levels is the name of the list on the row axis.