Regina Henschel wrote:
<quote>
If no constraint for a page field is given, the field's selected value
is implicitly used. If a constraint for a page field is given, it must
match the field's selected value, or an error is returned.
</quote>
This are my problems:
Where shall the page field be? As data field, or as part of a
constraint, or...?
If I use it as part of a constraint, then I know no way to use it
without an item to constraint it.
If I use it as data field, that is technical possible in the first
syntax, but it makes no sense to me and I cannot constraint it.
Can someone give me an example, how to use a page field in a
GETPIVOTDATA statement?
(Why is this on dba-users? It's a Calc feature.)
If you have a DataPilot table at A1 without page fields and with a data
field "Sales", GETPIVOTDATA("Sales";A1) will return the grand total.
If the table has a page field "Product", and "Apples" is selected in
that page field, GETPIVOTDATA("Sales";A1) or
GETPIVOTDATA("Sales";A1;"Product";"Apples") both return the total for
apples, and GETPIVOTDATA("Sales";A1;"Product";"Oranges") will return an
error.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
