Report Portal

ABC Classification - Dynamic

The dynamic version of the ABC Classification pattern is an extension of the Dynamic Segmentation pattern. It groups items (such as Products or Customers) into segments based on their cumulated sales and how much they contributed to the total sales across all items. Dynamic segmentation is calculated on the fly with respect to all the filters, unlike the static ABC Classification pattern, where segments are calculated during processing and are therefore independent of any filters later applied to the pivot table. Dynamic segmentation allows you to analyze how a specific item varies across regions or has moved between classes over time. In the pattern, you use a parameter table to define the boundaries of the different segments (see the Parameter Table pattern).

Read more...

Tags: design, dax, tabular

 

2007-2015 VidasSoft Systems Inc.