Hello experts!!!
I’m very new in Sap BO Webi and i have a problem, in my report in my columns at the tables which i created them i have duplicate items and i want to remove from my columns to keep one because they destroy my calcalation.
I hope someone replies as soon as possible to my question.
Thank you.
I’m using BO WebI 4,1 SP2.
P.S. Sorry for my English, i hope you will understand the meaning.
emmanuel gonianakis 
(BOB member since 2016-09-13)
Welcome to B:bob:B!
In the query panel, there is a button on the toolbar that says Query Properties when you mouse over it. Click on that, and you find an option there to retrieve duplicate rows. Uncheck that, and run your query again.
MichaelWelter 
(BOB member since 2002-08-08)
Thank you Michael for your help i appreciate it, i 've already find a solution and i posted the question because i couldn’t do it from the query properties and format table. I 've found the solution from the search bar from similar answers.
Thank you again for your help.
emmanuel gonianakis (BOB member since 2016-09-13)