Other way to use "Getpivotdata"?

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

Usually, we would define the following macro statement to
get value from an OLAP cube in Excel.

GETPIVOTDATA("[Measures].
[Sales]",$A$4, "[Months]", "[Months].[January]")

I would like to know whether there is another to
use "Getpivotdata". For example, assign an array
to "Getpivotdata".

Thanks!

Cindy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting getpivotdata formula using vba macro 2
sum of getpivotdata() 0
GETPIVOTDATA from OLAP cube - grouped field 0
If cell contains specific formula (GETPIVOTDATA) 1
getpivotdata doesn't like certain numbers?? 2
Getpivotdata Function 3
Use cell_ref in place of an item in get pivot data function 2
Can getpivotdata use a cell reference? 5

Back
Top