Field value treated like expression

[blednyi]

Hi !

I'm trying to do chart where expression is read in certain field. Why I am trying to do so:

I need pivot table where in different rows have different expression in same column... like you can do in spreadsheet. I know that variable could treated like expression, but I do not want create lots of variables.

I have tried many different ways to solve problem, one expression in above:

=GetFieldSelections

(sarake1)

And selected value in the field is: sum(myynti)

... really basic expression... but QV is treated field value like string

so how can I change string to expression ?

Any Ideas?

or is this too weird way to solve problem [:P]

[prieper]

Hi,

can you post an example? Might be worth to look at the original data.

Peter

[blednyi]

Here is example what I'm doing..

and find solution when using text-object, how to handle field value to expression:

=
$(=Column1Calc)

But in pivot table I'm not getting solutions[:'(]

[johnw]

I must not be understanding what you want, as the pivot table is picking up the same expression as the text object in both 8.5 and 9.0.

[Oleg_Troyansky]

your logic works just fine, except for the fact that multiple values are available for expressions 2 and 3. If you ensure that only a single value is available at all times, all the expressions will work correctly. You can also use function only(), to ensure that you only want the single available value.

Oleg