subrosumon
Board Regular
- Joined
- Mar 20, 2014
- Messages
- 124
Hi expert,
I am using multiple sheet pivot table with
[TABLE="width: 587"]
<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>[TR]
[TD="width: 100, bgcolor: #DDEBF7"]Month
[/TD]
[TD="width: 84, bgcolor: #DDEBF7"]Date[/TD]
[TD="width: 95, bgcolor: #DDEBF7"]Project Number[/TD]
[TD="width: 141, bgcolor: #DDEBF7"]Ledger[/TD]
[TD="width: 168, bgcolor: #DDEBF7"]Descriptions
[/TD]
[TD="width: 97, bgcolor: #DDEBF7"]Received[/TD]
[TD="width: 97, bgcolor: #DDEBF7"]Payment
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 587"]
<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>[TR]
[TD="width: 100, bgcolor: #DDEBF7"]Month[/TD]
[TD="width: 84, bgcolor: #DDEBF7"]Date[/TD]
[TD="width: 95, bgcolor: #DDEBF7"]Project Number[/TD]
[TD="width: 141, bgcolor: #DDEBF7"]Ledger[/TD]
[TD="width: 168, bgcolor: #DDEBF7"]Descriptions
[/TD]
[TD="width: 97, bgcolor: #DDEBF7"]Received[/TD]
[TD="width: 97, bgcolor: #DDEBF7"]Payment[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]OV-2000[/TD]
[TD="bgcolor: transparent"]20-Fee[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] 10,000 [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]PR- 2001[/TD]
[TD="bgcolor: transparent"]22-Accommodation[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] 1,000 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]PR- 2002[/TD]
[TD="bgcolor: transparent"]24-Advance[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] 2,000 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]PR- 2002[/TD]
[TD="bgcolor: transparent"]24-Advance[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] 3,000 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]PR- 2002[/TD]
[TD="bgcolor: transparent"]24-Advance[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] 1,000 [/TD]
[TD="bgcolor: transparent"] 9,000 [/TD]
[/TR]
</tbody>[/TABLE]
but result is showing project and ledger "0" - how can get ledger and project info?
[TABLE="width: 443"]
<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>[TR]
[TD="width: 95"]Sum of Value[/TD]
[TD="width: 104"][/TD]
[TD="width: 104"][/TD]
[TD="width: 104"][/TD]
[TD="width: 104"][/TD]
[TD="width: 79"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Project Number[/TD]
[TD]Ledger[/TD]
[TD]Received[/TD]
[TD]Payment[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"](blank)[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]11000[/TD]
[TD="bgcolor: transparent, align: right"]15000[/TD]
[TD="bgcolor: transparent, align: right"]26000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]February-2018[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]22000[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]22000[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]33000[/TD]
[TD="align: right"]15000[/TD]
[TD="align: right"]48000[/TD]
[/TR]
</tbody>[/TABLE]
I am using multiple sheet pivot table with
[TABLE="width: 587"]
<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>[TR]
[TD="width: 100, bgcolor: #DDEBF7"]Month
[/TD]
[TD="width: 84, bgcolor: #DDEBF7"]Date[/TD]
[TD="width: 95, bgcolor: #DDEBF7"]Project Number[/TD]
[TD="width: 141, bgcolor: #DDEBF7"]Ledger[/TD]
[TD="width: 168, bgcolor: #DDEBF7"]Descriptions
[/TD]
[TD="width: 97, bgcolor: #DDEBF7"]Received[/TD]
[TD="width: 97, bgcolor: #DDEBF7"]Payment
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 587"]
<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>[TR]
[TD="width: 100, bgcolor: #DDEBF7"]Month[/TD]
[TD="width: 84, bgcolor: #DDEBF7"]Date[/TD]
[TD="width: 95, bgcolor: #DDEBF7"]Project Number[/TD]
[TD="width: 141, bgcolor: #DDEBF7"]Ledger[/TD]
[TD="width: 168, bgcolor: #DDEBF7"]Descriptions
[/TD]
[TD="width: 97, bgcolor: #DDEBF7"]Received[/TD]
[TD="width: 97, bgcolor: #DDEBF7"]Payment[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]OV-2000[/TD]
[TD="bgcolor: transparent"]20-Fee[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] 10,000 [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]PR- 2001[/TD]
[TD="bgcolor: transparent"]22-Accommodation[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] 1,000 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]PR- 2002[/TD]
[TD="bgcolor: transparent"]24-Advance[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] 2,000 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]PR- 2002[/TD]
[TD="bgcolor: transparent"]24-Advance[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] 3,000 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]PR- 2002[/TD]
[TD="bgcolor: transparent"]24-Advance[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] 1,000 [/TD]
[TD="bgcolor: transparent"] 9,000 [/TD]
[/TR]
</tbody>[/TABLE]
but result is showing project and ledger "0" - how can get ledger and project info?
[TABLE="width: 443"]
<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>[TR]
[TD="width: 95"]Sum of Value[/TD]
[TD="width: 104"][/TD]
[TD="width: 104"][/TD]
[TD="width: 104"][/TD]
[TD="width: 104"][/TD]
[TD="width: 79"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Project Number[/TD]
[TD]Ledger[/TD]
[TD]Received[/TD]
[TD]Payment[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"](blank)[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]January-2018[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]11000[/TD]
[TD="bgcolor: transparent, align: right"]15000[/TD]
[TD="bgcolor: transparent, align: right"]26000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]February-2018[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]22000[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]22000[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]33000[/TD]
[TD="align: right"]15000[/TD]
[TD="align: right"]48000[/TD]
[/TR]
</tbody>[/TABLE]