G
george
How do I filter out the items that say NO CASH in the source spreadsheet
basically those fields are Blank. In the table properties for now I have
the
box checked IF EMPTY put in NO CASH. I would like the items that are
blank or NO CASH just not to appear in the table. Can this be automatic
each time I go into this pivot table? Basically the source spreadsheet is
updated
everyday.
MONTH 6
Sum of RECEIVED
DAYS Account RECEIVED FROM Total
6/1/2004 1074 Loan Payment $203,544.08
1080 G.Homes $200,000.00
1091 1st - CL $1,500.00
B&C - CL $3,950.00
Michael $329.50
William $1,950.00
1096 Cobra $1,386.36
3052 Distribution $26,455.92
4225 Ridge $900.00
McMullen $1,000.00
Rauch $1,000.00
Susi $1,000.00
4661 Group $540,000.00
7916 Corporation $70.00
8860 Charter $1,200.00
EC $13.30
9100 Fund $5,509.42
Rent $3,079.00
(blank) Construction No Cash
Block No Cash
Condominium Inc. No Cash
Charles No Cash
Construction No Cash
Budget, Mgmt & Fin No Cash
Fenn $186,647.73
First Management No Cash
Gary No Cash
Henrietta No Cash
Health No Cash
Joe No Cash
John No Cash
Justin No Cash
Lauria $296,990.00
Dental Plan No Cash
Payroll Account No Cash
Marc No Cash
Mark No Cash
Marotto $318,029.00
Mary No Cash
Mary No Cash
Matthew No Cash
Miller $180,536.92
Paul No Cash
Financial Group No Cash
Privateer $183,213.78
Fund No Cash
Remedy No Cash
Residence No Cash
Richard No Cash
Saxe $213,018.00
Town No Cash
Town No Cash
Victor No Cash
VOID No Cash
VOID CK No Cash
VOID CK No Cash
6/3/2004 1048 Nero $197,515.00
4055 First No Cash
(blank) America No Cash
Bills No Cash
Carl No Cash
Chad No Cash
Daryl No Cash
EC No Cash
Jason No Cash
Mark No Cash
Reger No Cash
Town No Cash
Town No Cash
Grand Total $2,568,838.01
basically those fields are Blank. In the table properties for now I have
the
box checked IF EMPTY put in NO CASH. I would like the items that are
blank or NO CASH just not to appear in the table. Can this be automatic
each time I go into this pivot table? Basically the source spreadsheet is
updated
everyday.
MONTH 6
Sum of RECEIVED
DAYS Account RECEIVED FROM Total
6/1/2004 1074 Loan Payment $203,544.08
1080 G.Homes $200,000.00
1091 1st - CL $1,500.00
B&C - CL $3,950.00
Michael $329.50
William $1,950.00
1096 Cobra $1,386.36
3052 Distribution $26,455.92
4225 Ridge $900.00
McMullen $1,000.00
Rauch $1,000.00
Susi $1,000.00
4661 Group $540,000.00
7916 Corporation $70.00
8860 Charter $1,200.00
EC $13.30
9100 Fund $5,509.42
Rent $3,079.00
(blank) Construction No Cash
Block No Cash
Condominium Inc. No Cash
Charles No Cash
Construction No Cash
Budget, Mgmt & Fin No Cash
Fenn $186,647.73
First Management No Cash
Gary No Cash
Henrietta No Cash
Health No Cash
Joe No Cash
John No Cash
Justin No Cash
Lauria $296,990.00
Dental Plan No Cash
Payroll Account No Cash
Marc No Cash
Mark No Cash
Marotto $318,029.00
Mary No Cash
Mary No Cash
Matthew No Cash
Miller $180,536.92
Paul No Cash
Financial Group No Cash
Privateer $183,213.78
Fund No Cash
Remedy No Cash
Residence No Cash
Richard No Cash
Saxe $213,018.00
Town No Cash
Town No Cash
Victor No Cash
VOID No Cash
VOID CK No Cash
VOID CK No Cash
6/3/2004 1048 Nero $197,515.00
4055 First No Cash
(blank) America No Cash
Bills No Cash
Carl No Cash
Chad No Cash
Daryl No Cash
EC No Cash
Jason No Cash
Mark No Cash
Reger No Cash
Town No Cash
Town No Cash
Grand Total $2,568,838.01