ShareOf Property

Sets or returns whether to show the values in selected categories as a percentage of their higher-level category.

Syntax

CategoryList.ShareOf

If True, this property shows the values in the selected categories as a percentage of their higher-level category.

Default: False

Boolean

Read/Write

This example sets the categories in the report as a share of a higher-level category.

Sub Main

   Dim objPPRep as Object

   Dim objCatList as Object

   Set objPPRep = CreateObject("CognosPowerPlay.Report")

   objPPRep.New "C:\Cubes and Reports\Great Outdoors.mdc"

   objPPRep.ExplorerMode = False

   objPPRep.Visible = True

   Set objCatList = objPPRep.CategoryList

   objCatList.Add 1, "Products" ,"Outdoor Products"

   objCatList.Each = False

   objCatList.ShareOf = True

   objPPRep.Columns.Add objCatList

   objCatList.Remove

   objCatList.Add 0, "Measures", "Revenue"

   objCatList.Each = True

   objCatList.ShareOf = False

   objPPRep.Rows.Add objCatList

   Set objCatList = Nothing

   Set objPPRep = Nothing

End Sub