How to do it…

  1. Create a new Dimension in the Master items library.
  2. In the dimension editor, select the expression editor for the field.
  3. Add the following expression:
=Aggr( 
    If(Rangesum(Above(Sum(Sales)/Sum(Total Sales),1,RowNo()))<0.8, 'A', 
     If(Rangesum(Above(Sum(Sales)/Sum(Total Sales),1,RowNo()))<0.9, 'B', 
      'C')), 
    (Country,(=Sum(Sales),Desc)) 
 ) 
  1. Set the label with ABCClassification.
  2. Click on Add Dimension.
  3. Click on Done.
  4. Now, add a Table object to the content area.
  5. Click on Add column and select Dimension, and then click on ABCClassification in the dimension list.
  6. Add a second dimension and select the Country field.
  7. Click on Add column and select Measure, and then type in the following expression. Label it as Sales:
=Sum (Sales) 
  1. Change the Number formatting of the Sales measure to Number.
  1. The result will look like the following screenshot:
  1. Add a Bar chart at the top of the content area.
  2. Click on Add dimension and select the Country field.
  3. Click on Add Measure and type in the following expression. Label it as Sales:
=Sum (Sales) 
  1. Under Appearance, go to Colors and legend and switch Colors to Custom.
  2. Select By expression and type in the following expression:
=Aggr( 
    If(Rangesum(Above(Sum(Sales)/Sum(Total Sales),1,RowNo()))<0.8, green(), 
     If(Rangesum(Above(Sum(Sales)/Sum(Total Sales),1,RowNo()))<0.9, Yellow(), 
      Blue())), 
    (Country,(=Sum(Sales),Desc)) 
 )

  1. The result will look like the following screenshot
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset