Skip to main content
Solved

ITEM formula

  • May 18, 2026
  • 3 replies
  • 18 views
G
New Here

Hi I’m trying to do a simple look up using ITEM.

I have Transaction list, which contains customer data and the Product Type. Product Type is Dimension data type.

I have created a Dimension that allocates each Product Type to a correspondent Business segment, which I created as another dimension.

In that given transaction list, I’m looking to add the business segment, I created another column with dimension business segment as data type and I’m using ITEM to bring the Business segment values.

ITem('IWSR - NRR Data'.ProductType.Name,'IWSR - Business Segments'.Name)

The formula returns nothing and does not flag any errors.

What could be the issue?

Best

G

 

Best answer by Julie Guérin

Hi ​@Guillermo Puls Cruz,

Could you add the mapping for Business Segment within the Product Type dimension? Is it a 1:1 mapping?

If so, your formula could look like this:

'IWSR - NRR Data'.ProductType.'Business Segment'

3 replies

Julie Guérin
Employee
Forum|alt.badge.img+9
  • Julie GuérinEmployee
  • Employee
  • Answer
  • May 18, 2026

Hi ​@Guillermo Puls Cruz,

Could you add the mapping for Business Segment within the Product Type dimension? Is it a 1:1 mapping?

If so, your formula could look like this:

'IWSR - NRR Data'.ProductType.'Business Segment'
    G
    New Here

    100% 

    Min Li
    Master Helper
    Forum|alt.badge.img+14
    • Min LiMaster Helper
    • Master Helper
    • May 18, 2026

    This may be because you are using product name to match business segment name.

    Here is another solution:

    1 go to product type dimension, add a new dimension property ‘Business Segment’, 

    2 assign a proper business segment to each product type

    3 go to transaction list and add in business segment by 'IWSR - NRR Data'.ProductType.‘Business Segment’

     

    Min Li

      Ask your question here!

      Terms & ConditionsAccessibility statement