I have a report that includes information that I need for a pivot table/graph. For this pivot table, I'm trying to show three things:
- Unit description
- Value
- Date since received:
- 30 days or less
- 30-60 days
- 61-90 days
- 91-180 days
- over 180 days
I should have four columns showing the value of the 3 unit descriptions, and a total column. The first row should be 0-30 days, second row 30-60, etc, and it will be showing the value of the units. Does that make sense? I just don't know how to do that with a pivot table, separating the days into different rows.
Any help is greatly appreciated!
Bookmarks