Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a dimension "department" with 10 different values, e.g. department Sales, department Trade, department Housekeeping and so on...
Now I would like to use set Analysis to show the n-value, e.g. the third one (department Housekeeping).
Is this somehow possible?
I can find out, that there are 10 different values by counting distinct the dimension. But how to pick different dimension values, without "naming" them in Set Analysis (because the departments could grow, I would like to use a number...)
I think FieldValue can be used to do what you want:
Count({$<department = {"$(=FieldValue('department', 3))"}>} Names)
I think FieldValue can be used to do what you want:
Count({$<department = {"$(=FieldValue('department', 3))"}>} Names)