on 2024 Feb 19 9:40 AM
Hello everyone, I am currently trying to create a data action that counts values based off of the members in my dimension. I have researched different methods and this is what I found suited it me as I need it so that I may reference the dimension it goes into so that I may call upon it in another function. My current formula is shown below and I am really struggling getting it to work as I want. If anyone could be of help I would greatly appreciate it!
Thanks! Ammar
Are you trying to count all service providers which in your case is 9 and write this number as a data intersection or you are assigning an index like 1,2,3 etc to each of the service providers. If latter is what you are doing the code will work but you need to specify the default members for each dimensions ( may be #) inside DATA() else it would try to write 1, 2 ,3 and so on all the combination of master data scope of dimensions which would be huge and I do not think thats the right way of approaching this.
Br.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.