on 2025 Mar 12 9:52 AM - last edited a month ago
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 |
---|---|
88 | |
10 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.