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?
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.
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
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.
sales quintiles.twbx 2.4 MB
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?
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.
As I understand, if you can define in excel,
if item id='1' then 'Item A',
if item id='2' then 'Item B',
else 'Item C' end
1 of 1 people found this helpful
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.