Hello Niklas,
Niklas Nebel schrieb:
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.)
You are right, but I have remembered to late that calc has a mailing
list too.
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.
That's how it works, and I expect that it works in this way. But it
makes the help text not clearer to me. Especially "If no constraint for
a page field is given, the field's selected value is implicitly used."
makes no sense to me.
What is a "constraint for a page field"? Do you mean a member/item of
the field? But then I see no way to use a page field inside the
GETPIVOTDATA statement without giving an item.
I guess, that the relationship in the English text is wrong and it is
not "for" but "by means of" (German: "mittels"). I guess it means, "If
no constraint by means of the page field item is given, then the field's
selected value is implicitly used. If a constraint by means of a page
field item is given, then it must match the field's selected value, or
an error is returned."
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
