上記のように３かつBのディメンションに入力される値のみを取得する方法はありますか？
※3-B(ラインアイテム)全てに100が入る形でも問題ありません
リストラインアイテムを使用したLOOKUPは試したのですが、Source module.valueが全項目それぞれ出てきました。
上記の他にSummaryなどの設定が必要でしょうか？
【追記】ディメンションを削除したところ、臨む値のみを取得することができました
TristanS ありがとうございました
Yes there is a way.
Step 1: Create a constants module with the following line items
SYS001 Constants
Line Item
Format
Formula
B Constant
List for B
finditem('List for B', "B")
3 Constant
List for 3
finditem('List for 3', "3")
Step 2:
Target module to have dimension specified in the rows of your example.
Value will be
Target module.target line item = Source module.value[Lookup: 'SYS001 Constants'.'B Constant', Lookup: 'SYS001 Constants'.'3 Constant']
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
