PowerPivotPro's FAQ Site

PowerPivotPro's FAQ Site > The Great PowerPivot FAQ > How can I do ABC Analysis (Pareto) with PowerPivot?

The Great PowerPivot FAQ: How can I do ABC Analysis (Pareto) with PowerPivot?

Title

How can I do ABC Analysis (Pareto) with PowerPivot?

Answer

You have to create a calculated column with the class (A, B or C) each line belongs to. In case of different ABC analysis (i.e. Products and Customers), you have to create one ABC column for each analysis.

Detailed instruction about DAX formula are available here: http://sqlblog.com/blogs/marco_russo/archive/2010/01/19/abc-analysis-in-powerpivot.aspx

Client/Server

Client

Topic

F - Calculations (DAX)

Purpose

Information

Answered?

Yes

Contributor

Marco Russo

Título

Resposta

Frage

Kann ich mit PowerPivot einfach eine ABC-Analysis (Pareto) erstellen?

Antwort

preRTM

Attachments