how to enable data option on a pivot table
 

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

how to enable data option on a pivot table
 

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

Jim Thomlinson


"Phoenix" wrote:

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

how to enable data option on a pivot table
 

ok

thanks a lot for your support

regards

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"Phoenix" wrote:

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