Forum Discussion
Matrix shows wrong total
Hi everyone. The following matrixes contain the same amounts but give different totals. If I export the tables they are based upon and make a pivot in excel to sum the Standard units per invoice, I...
Anonymous Do you need to do a remove duplicates step in your query?
Yes. I always refrained for some reason and rather understand where the duplicates generation happen.
But for now is a good enough solution, plus i wasn't aware that if i didn't select all the involved columns, Remove duplicates never works as you intend.
Thank you.