Omit the calculate lineitems by using Lineitem subsets
Options
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:
0
