上記のように３かつ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']
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
