Spreadsheet: 789069d1658884454-formula-to-work-inside-the-pivot-table-other-than-getpivotdata-need-help-with-formula-inside-the-pivot-table-other-than-getpivotdata
Sheet: Table

Inventory Acct | (Multiple Items) |  |  |  |  | 6074415.69 |  |  | S/B ZERO |  | Inventory Acct | (Multiple Items)
 |  |  |  |  |  |  |  |  | 0
Sum of Ending Balance |  |  |  |  |  |  |  |  | p-r pvt |  | Sum of Ending Balance
Country | Accnt | Accnt Desc | Total | % Tot | Elim share | Adjusted on hand | Elim | Chk | chk diff |  | Country | Elim Country | Total
Australia | 13110 | RAW | 37019.58 | 0.00841070327161371 | -11699.49851839646 | 25320.08148160354 |  |  |  |  | Elimination | Australia | -1391025
 | 13310 | FG - NEW | 771314.64 | 0.1752396587452248 | -243762.7463060764 | 527551.8936939236 |  |  |  |  |  | India | -2304983.46
 | 13312 | FG - JES | 0 | 0 | 0 | 0 |  |  |  |  |  | USA | -0.01
 | 13320 | FG - DEMO | 3345685.68 | 0.7601266544506216 | -1057355.179507176 | 2288330.500492824 |  |  |  |  | Elimination Total |  | -3696008.47
 | 13350 | FG - USED | 0.03 | 6.815882247945851e-09 | -0.009481062603948877 | 0.02051893739605112 |  |  |  |  | Grand Total |  | -3696008.47
 | 13610 | FG - SERVICE LOANERS | 247464.56 | 0.0562229767166577 | -78207.56618728877 | 169256.9938127112
Australia Total |  |  | 4401484.49 | 1 | -1391025 | 3010459.49 | -1391025 | 3010459.49 | 0
India | 13310 | FG - NEW | 1781224.78 | 0.3317647231669577 | -764712.1995113164 | 1016512.580488684
 | 13320 | FG - DEMO | 1256283.35 | 0.2339909608892867 | -539345.2946393127 | 716938.0553606874
 | 13610 | FG - SERVICE LOANERS | 2005210.5 | 0.3734835231878914 | -860873.3435306161 | 1144337.156469384
 | 13720 | DEFERRED COGS | 326221.03 | 0.06076079275586421 | -140052.6223187548 | 186168.4076812452
India Total |  |  | 5368939.66 | 1 | -2304983.46 | 3063956.2 | -2304983.46 | 3063956.2 | 0
Grand Total |  |  | 9770424.15
 |  |  | #REF!
 | 13805 | INV PROFIT HQ | 11916280.53
 | 13805 | INV PROFIT HQ | -11916271.54
 |  |  | 8.990000000223517
Sum of Ending Balance
Accnt | Country | Accnt Desc | Total
13650 | Australia | RESERVE - INTERNATIONAL | -1120473.06
 | Australia Total |  | -1120473.06
 | USA | RESERVE - INTERNATIONAL | -4951447.67
 | USA Total |  | -4951447.67
Grand Total |  |  | -6071920.73
Subinventory | (All) | 00:00:00
Item Family | NEO
 | Values
RM/FG | Sum of Onhand Value | Sum of Total Res | Sum of NBV
FG | 1820074.129999999 | 1820074.129999999 | 0
RM | 1909946.199999999 | 1909946.199999999 | 0
Grand Total | 3730020.329999998 | 3730020.329999998 | 0
Subinventory | (All)
Item Family | (Multiple Items)
 | Values
RM/FG | Sum of Onhand Value | Sum of Total Res | Sum of NBV
FG | 9137.7 | 9137.7 | 0
RM | 18372.8 | 18372.8 | 0
Grand Total | 27510.5 | 27510.5 | 0
Subinventory | (All) | 2022-06-30 00:00:00
Item Family | NEO
 | Values
RM/FG | Sum of Onhand Value | Sum of Total Res | Sum of NBV
FG | 1816560.809999999 | 1816560.809999999 | 0
RM | 1831344.48 | 1831344.48 | 0
Grand Total | 3647905.289999999 | 3647905.289999999 | 0
 |  | 00:00:00
Subinventory | (All) | 00:00:00
Item Family | (Multiple Items)
 | Values
RM/FG | Sum of Onhand Value | Sum of Total Res | Sum of NBV
FG | 421.06 | 421.06 | 0
RM | 23523.47 | 23523.47 | 0
Grand Total | 23944.53 | 23944.53 | 0
 |  |  |  |  | 3671849.819999999