Hello:
I am a first time poster to this forum. I appreciate in advance any help you can give me.
I am using a worksheet with a set of data. In column R, I have a "Due Date".
Column F is "Department".
I need to set up a pivot table that calculates how many items are due in the next 15 days and in the next 30 days by department.
I was able to use conditional formatting and set a formula to highlight the rows that are due in next 15 days Orange and next 30 days green.
I can add another column to my data to set a formula but can't figure out the cleanest way to count the ones that are due in the next 15 days/30 days.
I'm looking for a pivot chart that would show:
Count in the Y Axis
Departments in the X Axis
and 3 bar graphs that would show the number of items due in next 15 days in first, then 30 days in next, and past due in third.
Any help would be greatly appreciated. Thank you so much.
I am a first time poster to this forum. I appreciate in advance any help you can give me.
I am using a worksheet with a set of data. In column R, I have a "Due Date".
Column F is "Department".
I need to set up a pivot table that calculates how many items are due in the next 15 days and in the next 30 days by department.
I was able to use conditional formatting and set a formula to highlight the rows that are due in next 15 days Orange and next 30 days green.
I can add another column to my data to set a formula but can't figure out the cleanest way to count the ones that are due in the next 15 days/30 days.
I'm looking for a pivot chart that would show:
Count in the Y Axis
Departments in the X Axis
and 3 bar graphs that would show the number of items due in next 15 days in first, then 30 days in next, and past due in third.
Any help would be greatly appreciated. Thank you so much.
