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 table. However, some of my samples comes on a few days of the week, I listed them in the format like this MON/TUES. Please see table below. I am hoping they appear on their individual only. EG: SUN, MON, TUES..
| SUN | 18 |
| MON | 83 |
| TUE | |
| WED | 78 |
| THU | 111 |
| FRI | 21 |
| SAT | 3 |
| FRI/SUN | |
| MON/FRI | 7 |
| MON/THU | 5 |
| MON/THU/SAT/SUN |
|
1 Reply
- 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
