Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
For a number of reasons, I don't want to let my pivot table object "handle" my second dimension as a horizontal dimension as one would normally do.
Instead, I would like to have a number of identical expressions, with my exprea formular that with a set expression does a simple count, looking up a field:
I can get this to work:
=count({1<TYPE = P(), CATEGORY = {$(=FieldValue('CATEGORIES', 1 ))}>} DISTINCT ID)
But not the dynamic one:
=count({1<TYPE = P(), CATEGORY = {$(=FieldValue('CATEGORIES', ColumnNo() ))}>} DISTINCT ID)
I suspect I am missing something with ColumnNo() and have tried enclosing with $(=) and alike, but have not succeeded.
Any help with this one?
/Nicolai
Alright...the columnno() only works over dimension, and not over let's say 4 different expressions.
Any way of fetching the expression number in a pivot or the column number in any other ways?
Which by the way, seems a little odd, when you can get the result of the other expressions using column(x), so they must have a number. Any ideas?