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
Category	Forecast	Lineitem	A_forecast	Value	100
Category		Lineitem	B_forecast	Value	10
Category		Lineitem	C_forecast	Value	200
Category		Lineitem	・・・	Value
Category		Lineitem	ALL_forecast	Value	300
Category	Actual	Lineitem	A_actual	Value	120
Category		Lineitem	B_Actual	Value	20
Category		Lineitem	C_Actual	Value	220
Category		Lineitem	・・・	Value
Category		Lineitem	ALL_Actual	Value	340
Category	error	Lineitem	A_error	Value	-20
Category		Lineitem	B_error	Value	-10
Category		Lineitem	C_error	Value	-20
Category		Lineitem	・・・	Value	0
Category		Lineitem	ALL_error	Value	-40
Category		Lineitem		Value

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	Forecast	100	Actual	120	error	-20
	B	Forecast	10	Actual	20	error	-10
	C	Forecast	200	Actual	220	error	-20
	・・・	Forecast		Actual		error
	ALL	Forecast	300	Actual	340	error	-40
		Forecast		Actual		error

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.