Skip to Content
0
Former Member
Sep 23, 2016 at 09:55 AM

Issue with aggregation

15 Views

Hi All,

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!