Item Category as Dimension

(0) Share

Report

Posted on by MarisolC

103

In the Item Card we have this field called Item Category Code is possible to use this category as dimension in a Sales Report Analysis or just in a regular dimension analysis?

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

YUN ZHU 95,718 Super User 2025 Season 2 on at

Like (1)

Report

Hi, I think this is not possible in standard functions.
But you can manually create a Dimension of Item Category Code to keep them the same value.

You can also do a small customization that automatically updates the default dimension when you update the Item Category Code on the page.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
MarisolC 103 on at

Like (0)

Report

Thks :(

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

This is a possible option too: joshanglesea.wordpress.com/.../

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

To add to other comments. If you want to take the data to Excel (thatnavguy.wordpress.com/.../) or Power Bi then you can use that. You basically create a relationship and add a new column to report that uses item category.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

What you do not get with wordpress or power bi is financial reporting based on your item category. If you setup as a dimension, you can then do financial analysis by categroy.

Was this reply helpful? Yes No
Dallefeld 211 User Group Leader on at

Like (0)

Report

Sorry, let me clarify....

l was referring to (thatnavguy.wordpress.com/.../) or Power Bi, specifically

Was this reply helpful? Yes No