how to enable data option on a pivot table

P

Phoenix

Hi all,

when i use a pivot table with external data source (a cube or a perpective),
i have two options unavailable (on the pivottable options, data tab) :
Save source data with file
Number of items to retain per field

these two options are grey.
How I can enable these two options ?

thanks
regards
 
J

Jim Thomlinson

In short you can't. The pivot table is just an interface into the cube. When
you base a pivot table off of a cube you lose a bunch of functionallity.
 
P

Phoenix

ok

thanks a lot for your support

regards

Jim Thomlinson said:
In short you can't. The pivot table is just an interface into the cube. When
you base a pivot table off of a cube you lose a bunch of functionallity.
Click to expand...
 
Top