Omit the calculate lineitems by using Lineitem subsets

Hi, I want to omit calculate Lineitems by using Lineitem subset.

I have these Lineitems. I have to calculate each(A,B,C…) error(= Forecast - Actual) .

But in this table , I have to create at least 4Lineitems and input formulas.

Category

Lineitem

Value

Forecast

A_forecast

100

B_forecast

10

C_forecast

200

・・・

ALL_forecast

300

Actual

A_actual

120

B_Actual

20

C_Actual

220

・・・

ALL_Actual

340

error

A_error

-20

B_error

-10

C_error

-20

・・・

0

ALL_error

-40

Then, I want to calculate error efficiently like this table.

I think I should use Lineitem subset. But Lineitem subset can have only 1 set.

Lineitem subset cannot have 2 set like Forecast and Actual.

Forecast

Actual

error

A

100

120

-20

B

10

20

-10

C

200

220

-20

・・・

ALL

300

340

-40

Do you have any idea to achieve this?

Tagged:

Answers

  • There is an option to compare two list items in Anaplan. You can read more on Anapedia by clicking here.