I need help related to pivot data in MS Excel

Asked By carl gock 30 points N/A Posted on - 08/29/2012

Hi friends,

I need help related to pivot data in MS Excel. While retrieving data from pivot table using getpivotdata, the formula used contains cell $C$4, $D$4, these cells are dropdown menus, where the users could choose the values as they want.

I want to know whether is it possible to use =GETPIVOTDATA(“Sum of vol 1”,”’”&”!$A$4”,”Month”,$C$4,”country”,$D$4), G4 being “sum of vol 1”. I want to use this because I have two pivot tables.

Please help me.

• Status: Open
• Question Views: 834
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Office

Answered By Willet Engelin 0 points N/A #152868

I need help related to pivot data in MS Excel

Hi there,

GOOD DAY!

Here you are provided Excel 2007 pivot table

Get pivot Data with Drop-Down lists:

Get Pivot Data arguments are different in Excel 2000 and if you create formulas in the earlier version, Excel 2003 can calculate them .But excel 2000 can’t calculate the newer version’s format.

You can use indirect will only work if the target workbook is open, although it could be constructed to calculate the correct file name based on another value such as cell

If cell between the page field and the main table body (which fails, IME)

Usage of cell reference at the field of building code ignoring number can error the work.

Use the following link to learn about pivot data:

Pivot data in a pivot table or pivotchart report

You can try:

Pivot table report 101

How to create pivot tables in excel

Learn about Pivot table

KEEP USING…..

 

 

About Willet Engelin

Questions
0

Answers
103

Best Answers
30

• Vote Up 0 Vote Down

• Posted on - 08/31/2012
• Question Category: Microsoft Office