How to add a having clause for my report?

[AmbroseW]

Hi, I am asked to create a report where showing users that are assigned with two or more computers.I couldn't find the having clause or related list condition. Is there anyway to achieve the desired result? 

[sachin_namjoshi]

You need to use "Group by" in report and then group by assigned to show users with multiple computers like below

Regards,

Sachin

[Onkar Pandav · Accepted solution]

Hi,

In addition to above reply, you can also give filter condition as per your requirement.

Please refer below screen shot.

[Bhanu Kiran]

We’ve created a new article on this topic, you can find it here KB0828597, so other Customers with similar questions can easily find a solution in our Knowledgebase. We hope you find it helpful!

[Namrata Khabale]

Hey AmbroseW,

In addition to Onkar's Point i would like to suggest try like  this:

To get it to work your source table isUsers [sys-user] and under related list conditions select Asset -> Assigned to and change the Greater than or Equal to to 2

Refer the screenshot it will help you:

Mark Correct and Helpful if it solves your issue!

Best Regards,

Namrata.