Forum Discussion

Charlie300's avatar
Charlie300
Copper Contributor
Oct 13, 2023

Different field data in the same row within a Piviot Table

Hi folks!

First time posting and I'm after some pivot table help.

 

My question is, is it possible to have different field data in the same row within a pivot table i.e. serial number, Fan, Low and Core on the same line? see below.

 

Thanks!

 

 

Excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Oct 13, 2023

    Charlie300 When inside the pt, on the Design tab set the Report layout to "Tabular Form". You may also switch off Subtotals if you want.

     

     

Resources