Forum Discussion
tdc-studio
Mar 29, 2020Copper Contributor
How to Include a Text Field in an Excel Pivot Table
I am trying to summarise product orders in a Pivot Table and I want to include the Unit Type with each summarised value. For example, each day customers order fruit and my data has the following fiel...
Tkuhn
Mar 29, 2020Copper Contributor
tdc-studio If you put the unit type in the row area of the pivot table field list below product field and then change the report layout to tabular form. You can then remove subtotal.