Omit the calculate lineitems by using Lineitem subsets

CommunityMember125605

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?

saket22

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