Corporate Roll up

[koay9f]

If doing a roll up and mixing regression and actual data, the roll up cannot add some fields

Regression:
Auto names energy data as "Actual XX" and "Actual YY"
(XX and YY come from the column names)

Actual data:
Auto names energy data as "XX" and "YY"
(XX and YY come from the column names)

So when you do the roll up, Excel doesn't know to add "XX" + "Actual XX"

Solution: where change name of results fields in "Actual Data" to also be "Actual XX" instead of "XX"