| Action | ShowPareto
|
| Description | Choose a pareto function around a dimension cell.
|
| Examples | Dim po As OlapXParetoOption
po = OlapXPOPSum
With Cube1
Call .setValue("Row", 1)
Call .setValue("Col", 1)
Call .setValue("AutoPareto", po)
End With
|
| Example Explanation | Shows the pareto ask for value dialog to create a pareto function.
|
| Examples | Dim po As OlapXParetoOption
Dim pt As OlapXParetoType
po = OlapXPOPPercent
pt = OlapXORTop
With Cube1
Call .setValue("Row", 1)
Call .setValue("Col", 1)
Call .setValue("AutoPareto", po)
Call .setValue("ParetoValue", 80)
Call .setValue("ParetoRegType", pt)
Call .DoAction("Refresh")
End With
|
| Example Explanation | Sets a pareto function of top 80% around the chosen cell.
|
| See also |
| SetValue | Sets a control variable
|
|
| Notes | The data matrix grid begins at (0, 0) at its top left cell.
|