2025 Mar 12 9:52 AM - edited 2025 Mar 24 8:05 AM
Hi,
I am trying to create a calculated dimension in a story with IF condition on Account dimension + Functional Area dimension.
While Functional area is available in the editor selector, I can not add Account dimension :
I am using an optimized story.
Any ideas why I am not able to operate with Account dimension ?
Thank you,
Yulia
Hi,
Many thanks for the inputs.
I need to build a calculated dimension /calculated measure with cross dimensional reference.
IF condition on Functional area dimension in combination with some members from alternate hierarchy of Account dimension.
I tried to follow your suggestion with ACCOUNTLOOKUP function ,but looks like it's not possible to use with alternate hierarchy of account :
Would appreciate any suggestions on how this can be achieved,
Thank you
Request clarification before answering.
Account dimension behaves similar to a measure.
1. You can create Restricted account
Or you can use this function in Calculated Measure.
Need more details on the requirement.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
21 | |
8 | |
7 | |
6 | |
6 | |
4 | |
4 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.