# 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:

0