https://bugs.documentfoundation.org/show_bug.cgi?id=172337
--- Comment #3 from Kevin Suo <[email protected]> --- (In reply to m_a_riosv from comment #2) > It happens because there are two different 'Document_Num' for the same > 'Product_Name'. I know there are two document numbers for the same product code, but I am not sure whether you mean it is a bug or not. There may be millions of document numbers for one product code, but as long as I do not put document number in row labels, then pivot table should not produce one separate row for each document number. i.e., if the data is: ''' Document Num Product Code Product Name SOUT00172087 010304017 苯并三氮唑（BTA) SOUT00172084 010304017 苯并三氮唑（BTA) SOUT00172084 010304017 苯并三氮唑（BTA) ''' and I use "Product Code" and "Product Name" as row labels in pivot table, then it should produce: ''' Product Code Product Name Sum - Prod QTY 10304017 苯并三氮唑（BTA) 6 ''' and yes,currently Calc correctly generates a pivot table with the correct result if you use the above simple data. But unfortunately, Calc produces wrong pivot table with the data in attachment 207326. So there may be somewhere else going wrong. -- You are receiving this mail because: You are the assignee for the bug.
