I have 2 universe being pulled into a WEBi report
Universe A has vendor number, document number and overdue to be paid amount
Universe B has vendor number and total vendor amount
I have joined on vendor number
In the table I have all of universe A.
I used break so I could hide the document numbers and just show the total amounts by vendor and it can be expanded if the user wants more detail.
When I try to put Universe B's total vendor amount in, it only shows the sum of all the vendors, not vendor number by vendor number.
I've looked at ForEach and In functions but I could do with some expert help!