Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
is it possible to use the dimensionality() function in a set analysis? And how?
something like
sum( {<level = { $(=dimensionality()) }>} sales)
but this doesn't seem to work.
It won't work as you expected since the dollar sign expansion $(=dimensionality()) will be performed even before the expression will be parsed and evaluated. So it has in fact nothing to do with the abilities of set analysis (though it's true that set analysis does not consider chart dimensions, but is evaluated once).