7 Replies Latest reply on Jan 3, 2019 5:35 AM by Ken Flerlage

A,B,C Analysis

Hi,

I have a dimension called Item which contains all items being sold.  I would like to be able to create dimensions which are split to A items, B items, and C items.  Any idea how I can do this?

The final objective is to reate a Parameter which allows the user to select from the options Item, A item, B item, or C item and have the corresponding items returned.

Any and all suggestions are welcome.

Thanks,

Eric

• 1. Re: A,B,C Analysis

How are they classified as A, B, and C? What is the logic for splitting them up? Also, how do you intend to visualize it when you've done this? Any chance you can provide a sample workbook?

• 2. Re: A,B,C Analysis

Hi Ken,

I have done the A,B,C already in an excel, so I know which items should be A,B,C.    I've included a screen shot to help explain further.  Currently there is a dimensions which is called Customer Item Id which contains all items.  In theory what I´d like to do is create another dimension called A items and say Customer Item Id ="1, 2, 3" and then the same for B Items, etc.  Obviously this doesn´t work.  I hope this helps a bit, if not I wll try and include more information.

• 3. Re: A,B,C Analysis

Hi Eric

I have attached an analysis that breaks sales into quintiles by customer name - (you can use that as an analogy to ABC analysis

The process is involved and relies heavily on table calculations - that will make using the parameter you suggest difficult - see the lookup filter on the summary sheet

Good luck

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• 4. Re: A,B,C Analysis

Why separate dimensions though? Why not just create a new field (using a group or a calculated field) which has the values, A, B, or C? Then use that new field for your analysis? What is the end result you're shooting for?

• 5. Re: A,B,C Analysis

Hi Ken,

No reason behind separate dimensions, it was just what I had in my head.  I'm more then open to other suggestions, this is why  I'm asking for help in the first place.  What I´d like to do finally is allow the user to see inventory accuracy per item class.  So, they could select all items, or only A items, or only B items, etc and see KPIs depending on item class.

Thanks,

Eric

• 6. Re: A,B,C Analysis

Hi ERIC,

As I understand, if you can define in excel,

try

if item id='1' then 'Item A',

if item id='2' then 'Item B',

else 'Item C' end

YT

• 7. Re: A,B,C Analysis

Okay, gotcha. I'd suggest just using a new field as I noted above. You could then create a filter on that field to allow people to choose any combination of groups A, B, & C. The key will be creating that field. If you have logic in your data already that would help to determine which group they are in, then you can create a calculated field. Otherwise, you can manually create a group.

1 of 1 people found this helpful