Sum negative Values in Categories itembased without item-Dimension

[#1]

Hi,

i have a problem with following Usecase:

I have to get the negative itembased values in a category without getting the itemsdimension into my sheet. The data strukuture is like this: categories - orders - order_items - items. In my sheet i sum all values at the category level, but also sum the values at the item level for an optimization.

Now the Problem is, that i have to use a dimension, not shown, to get the correct values, but i have to get the first dimension"Controllin" sumed. At the end, there should be just one entry for "Apple" that contains all the value, but also shows the negative value inside the categories.

If there are any unclear points, ask please, and i post a new picture that contains all informations.

thanks Rico

[swuehl]

Sorry, I don't get your setting and requirements yet.

Could you maybe post a small sample file (QV or excel) together with a table showing your expected outcome?