Forum Discussion
PIvot table - text including field in column
Hi, I am using pivot table to organize my data. I am unsure of how to explain this. I have a list of samples which comes on different days of the week, and I am looking to sum them up in a pivot tabl...
Use the Data Table - rather then using Pivot table. Set Filters to Say
Days Containing "Mon" and use Subtotal Function in the last row, this
way you will get total for the Monday, and repeat this function for each
day of the week