Item Category as Dimension

(0) Share

Report

Posted on by MarisolC

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?

All responses (6)

Answers (1)

Dallefeld 169 User Group Leader on at

Like (0)

Report

RE: Item Category as Dimension

Sorry, let me clarify....

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

Dallefeld 169 User Group Leader on at

Like (0)

Report

RE: Item Category as Dimension

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.
Suggested answer

MahGah 15,433 on at

Like (0)

Report

RE: Item Category as Dimension

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.
Suggested answer

JAngle 46 on at

Like (0)

Report

RE: Item Category as Dimension

This is a possible option too: joshanglesea.wordpress.com/.../
MarisolC 60 on at

Like (0)

Report

RE: Item Category as Dimension

Thks :(
Verified answer

YUN ZHU 75,723 Super User 2024 Season 2 on at

Like (1)

Report

RE: Item Category as Dimension

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