Excel pivot not displaying correct data

%3CLINGO-SUB%20id%3D%22lingo-sub-1398008%22%20slang%3D%22en-US%22%3EExcel%20pivot%20not%20displaying%20correct%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1398008%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20a%20pivot%20table%20which%20shows%20data%20from%202%20adjacent%20cells%20(in%202%20rows)%20when%20I%20want%20the%20data%20from%20one%20row%20at%20a%20time.%20Basically%20I%20values%20in%20my%20pivot%20table%20according%20to%20data%20in%20rows%20and%20the%20problem%20is%20that%20for%20some%20of%20the%20values%20the%20data%20in%20two%20successive%20rows%20are%20added.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20screenshot%2C%20I%20have%20the%20data%20I%20want%20for%200.4%25%20and%200.6%25%20but%20I%20have%20two%20values%20for%20.7%25%20which%20is%20my%20problem.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1398008%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1398225%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20pivot%20not%20displaying%20correct%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1398225%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F670674%22%20target%3D%22_blank%22%3E%40praneel2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20share%20the%20data%20set.%20Must%20be%202%20entries%20corresponding%20for%200.7%25.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi, I have a pivot table which shows data from 2 adjacent cells (in 2 rows) when I want the data from one row at a time. Basically I values in my pivot table according to data in rows and the problem is that for some of the values the data in two successive rows are added. 

 

In the screenshot, I have the data I want for 0.4% and 0.6% but I have two values for .7% which is my problem. 

 

Thank you in advance for the help.

1 Reply
Highlighted

@praneel2020 

Can you share the data set. Must be 2 entries corresponding for 0.7%.