Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Where exactly are you trying to do this in the attached qvw? Also, can you provide the expected output based on the sample provided.
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
@sunny_talwar another one that got lost if you have time.
Cheers,
Brett