Multiple Sheet pivot table

[subrosumon]

Hi expert,
I am using multiple sheet pivot table with

Month

Date

Project Number

Ledger

Descriptions

Received

Payment

<colgroup><col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3490;"><colgroup><col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 2932;"><colgroup><col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3304;"><colgroup><col width="141" style="width: 106pt; mso-width-source: userset; mso-width-alt: 4910;"><colgroup><col width="168" style="width: 126pt; mso-width-source: userset; mso-width-alt: 5864;"><colgroup><col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3397;" span="2"><tbody>
</tbody>

Month	Date	Project Number	Ledger	Descriptions	Received	Payment
January-2018		OV-2000	20-Fee		10,000
January-2018		PR- 2001	22-Accommodation			1,000
January-2018		PR- 2002	24-Advance			2,000
January-2018		PR- 2002	24-Advance			3,000
January-2018		PR- 2002	24-Advance		1,000	9,000

<colgroup><col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3490;"> <col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 2932;"> <col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3304;"> <col width="141" style="width: 106pt; mso-width-source: userset; mso-width-alt: 4910;"> <col width="168" style="width: 126pt; mso-width-source: userset; mso-width-alt: 5864;"> <col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3397;" span="2"> <tbody> </tbody>

but result is showing project and ledger "0" - how can get ledger and project info?

Sum of Value
	Project Number	Ledger	Received	Payment	Grand Total
(blank)
January-2018	0	0	11000	15000	26000
February-2018	0	0	22000		22000
Grand Total	0	0	33000	15000	48000

<colgroup><col width="95" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3328;"><colgroup><col width="104" style="width: 78pt; mso-width-source: userset; mso-width-alt: 3630;" span="4"><colgroup><col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2746;"><tbody>
</tbody>

 

[steve the fish]

They would have to go in the rows area not the values area. They aren't numbers.