subrosumon
Board Regular
- Joined
- Mar 20, 2014
- Messages
- 124
Hi expert,
I am using multiple sheet pivot table with
<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>
<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?
<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>
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 |
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>