Pivot Chart Help

[ch33748]

I need help in creating a pivot chart displaying the total revenue expected per month over all jobs.

The data would need to be subtotaled per phase to get the correct data but I want to quickly capture it in a pivot chart.

TASK	ASSIGNED TO	SOV	SOV REMAINING	PROGRESS	START	END	DAYS	REV PER DAY
COURTHOUSE	JOHN	$ 95,000.00	$ 47,500.00	50%	1-Jan-23	23-Sep-23	266
	U/G STORM ROUGH PHASE III	JOHN	$ 45,000.00	$ 9,000.00	80%	13-Mar-23	2-Jun-23	82	$ 548.78
	U/G DOMESTIC WATER	JOHN	$ 35,000.00	$ 17,500.00	50%	20-Feb-23	15-Apr-23	55	$ 636.36
	U/G STORM ROUGH PHASE IV	JOHN	$ 15,000.00	$ 13,500.00	10%	15-May-23	7-Aug-23	85	$ 176.47
MIDDLE SCHOOL	BILL	$ 92,350.00	$ 80,806.25	13%	1-Nov-22	26-Sep-23	330	$ 279.85
	AREA A	BILL	$ 20,000.00	$ 11,000.00	45%	7-Jul-22	27-Jun-23	356	$ 56.18
	AREA B	BILL	$ 15,000.00	$ 10,500.00	30%	21-Jul-22	14-Jul-23	359	$ 41.78
	AREA C	BILL	$ 30,000.00	$ 22,500.00	25%	4-Aug-22	8-Aug-23	370	$ 81.08
	AREA D	BILL	$ 10,000.00	$ 9,000.00	10%	9-Jun-22	28-Jun-23	385	$ 25.97
	AREA E	BILL	$ 2,500.00	$ 2,125.00	15%	12-May-22	15-May-23	369	$ 6.78
	AREA F	BILL	$ 3,000.00	$ 2,700.00	10%	21-Apr-22	25-Sep-23	523	$ 5.74
	AREA G	BILL	$ 1,850.00	$ 1,757.50	5%	31-Mar-22	13-Mar-23	348	$ 5.32
	OUTBUILDINGS	BILL	$ 10,000.00	$ 9,500.00	5%	18-Aug-22	28-Sep-23	407	$ 24.57

 

[awoohaw]

well, that makes it very difficult. what are all the headers of the first two rows?

 

[awoohaw]

@ch33748 , okay,well... I understand you need to manipulate numbers and so forth to work out logistics and projects. But, that should be done outside of your reporting data. What do you do with your information after you are satisfied with how you have worked the numbers for each project?

 

[ch33748]

Maybe its just a formula that is needed.

If the cell falls within a date range, then I would like to calculate the "PER DAY REV" by number of days within that date range.

 

[awoohaw]

Maybe its just a formula that is needed.

If the cell falls within a date range, then I would like to calculate the "PER DAY REV" by number of days within that date range.

which cell are you wanting to compare the date ranges to? Although, I do not see any reason to use a cell to compare a date if you already have the date ranges, unless you have a date somewhere that says "Expenses on this day".

A formula to calculate Revenue per day would be:

=Revenue / (DateEnd - DateStart + 1)

(If you don't need revenue on day 1 then don't use the "+1".

And which cell has the value that is to be divided.