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
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.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.