Regina Henschel wrote:
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.
That's the second example. The formula doesn't give a constraint for
"Product", but "Apples" is used because it's selected in the page field.
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.
A field/item pair where the field is a page field.
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."
No, I mean a constraint given in the formula.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
