business-objectswebi

MAX aggregation of rows in Webi

I can't figure out how to show only example results for a field in a WebI table.

I have a data set in WebI with agents and agents' companies, among other things. The data set contains multiple companies for some agents, or with slight variations (e.g. "ACME Co." v. "ACME Company"). I want my report table to show each agent only once, with one of the values for the company next to it rather than new lines for each agent/company combination.

So the data is like:
Agent | Company -|- Agent A| Company 1
Agent A| Company 2
Agent B| Company 3
Agent B| Company 4

...and I want my table to show only:
Agent | Company -|- Agent A| Company 1
Agent B| Company 3

Thanks for your help.

Solution

  • Assuming you have no other objects in your report block that are nonunique within the Agent, you can simply use:

    =[Agent]
=Max([Company])