[ryan.austria Contributions: 0Level 1☆]

Is there a way to get a result with non-repetition of vendor name in saved searches if that vendor have multiple transaction?

Sample scenario :

As seen with the screenshot, one supplier (Best Inc. Limited) is equivalent to one transaction.

What we wanted to be the output or expected result is one supplier/vendor with multiple transaction.

See below screenshot.

Note : It cannot be done with saved report because I have already created formula for 'Price' column.

Thank you.

Attached Files
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC Contributions: 0Level 1☆]

This is not possible. Export your results to Excel, then do some excel gymnastics to achieve that there.

[JohnCCole Contributions: 0Level 1☆]

Sorry didn't see the price was a formula field. Please disregard the below.

If there are no formula, sum, group fields in the search results could you not create an Advanced PDF Template? In the advance PDF template you could track the previous company with a variable so you could compare it against the current row, and if the company is the same as the previous don't print it.

[Author]

Posts