Problem with calculated Dimension +-

[dominikkeller]

Hello everybody,

my problem is the right expressionin my dimension.

The goal is ... I have a billing ID and a Workplace ID. In my table I have to show which outlet has which costs / income. So I have to summarize all outlets (Workplace ID / Billing ID) in my dimension and that the expression is set against each other there.

So if Outlet A lend CoWorker for $ 100 to Outlet B and Outlet C lend CoWorker for $ 50 to Outlet A the result should be

Outlet A + $ 50

Outlet B-$ 100

Outlet C-$ 50

thanks for helping me

[sunny_talwar]

Where exactly are you trying to do this in the attached qvw? Also, can you provide the expected output based on the sample provided.

[dominikkeller]

Hey,

good Point.

I build the table on the sheet Copy of Copy of PersoWB.

In my first file the was a mistake so here is the right one.

The Table and the expressions are what i need. But the problem is an Outlet can send & recieve coworkers from others. Untill now im just able to present which outlet is sending people or in another table which is recivieng. I hope you get the idea.

Thank you

[Brett_Bleess]

@sunny_talwar another one that got lost if you have time.

Cheers,
Brett