SOLVED

Pivot Table Help!!!

%3CLINGO-SUB%20id%3D%22lingo-sub-3293886%22%20slang%3D%22en-US%22%3EPivot%20Table%20Help!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293886%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20with%20regard%20to%20the%20Pivot%20table.%20In%20the%20first%20screenshot%2C%20the%20instructor%20has%20dragged%20Product%20and%20Year%20in%20the%20rows%20and%20we%20can%20see%20that%20they%20are%20coming%20side%20by%20side%20but%20when%20I%20attempted%20the%20same%20things%20they%20are%20not%20coming%20in%20the%20same%20format.%20Kindly%20advise%20me.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PV%201.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F366550iB71724240E886A41%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22PV%201.png%22%20alt%3D%22PV%201.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PV%202.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F366549iFA76F8BB5E5F6474%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22PV%202.png%22%20alt%3D%22PV%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3293886%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3293904%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Help!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293904%22%20slang%3D%22en-US%22%3EThank%20You%20Riny%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3293893%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Help!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293893%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1371826%22%20target%3D%22_blank%22%3E%40Cmpunk%3C%2FA%3E%26nbsp%3BOn%20the%20Design%20tab%2C%20choose%20Report%20layout%2C%20Tabular%20Form.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Riny_van_Eekelen_0-1650890874171.png%22%20style%3D%22width%3A%20287px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F366551iB8DE5ACCDD2CA085%2Fimage-dimensions%2F287x190%3Fv%3Dv2%22%20width%3D%22287%22%20height%3D%22190%22%20role%3D%22button%22%20title%3D%22Riny_van_Eekelen_0-1650890874171.png%22%20alt%3D%22Riny_van_Eekelen_0-1650890874171.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello All,

 

I need help with regard to the Pivot table. In the first screenshot, the instructor has dragged Product and Year in the rows and we can see that they are coming side by side but when I attempted the same things they are not coming in the same format. Kindly advise me.PV 1.pngPV 2.png

2 Replies
best response confirmed by Cmpunk (Occasional Contributor)
Solution

@Cmpunk On the Design tab, choose Report layout, Tabular Form.

Riny_van_Eekelen_0-1650890874171.png

 

Thank You Riny