Multiple Sheet pivot table

subrosumon

Board Regular
Joined
Mar 20, 2014
Messages
124
Hi expert,
I am using multiple sheet pivot table with
Month
DateProject NumberLedgerDescriptions
ReceivedPayment


<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>
MonthDateProject NumberLedgerDescriptions
ReceivedPayment
January-2018OV-200020-Fee 10,000
January-2018PR- 200122-Accommodation 1,000
January-2018PR- 200224-Advance 2,000
January-2018PR- 200224-Advance 3,000
January-2018PR- 200224-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 NumberLedgerReceivedPaymentGrand Total
(blank)
January-201800110001500026000
February-2018002200022000
Grand Total00330001500048000

<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>
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,080
Office Version
365
Platform
Windows
They would have to go in the rows area not the values area. They aren't numbers.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,682
Messages
5,488,240
Members
407,632
Latest member
varunwalla

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top