Action ShowCubeView Description Sets the way the cube data will show Examples With Cube1  Call .setValue("Row", 1)  Call .setValue("Col", 1)  Call .setValue("AutoCubeView", 1)  Call .setValue("FormulaValue", 7)  Call .DoAction("ShowCubeView") End With Example Explanation Shows the cube view dialog if needed and refreshes the cube view. See also SetValue Sets a control variable Notes The data matrix grid begins at (0, 0) at its top left cell. The formula values are only need when AutoCubeView equals 9 and 10. The AutoCubeView variable can have one of the following values: Value 0 Values 1 % of Total 2 % of Parent 3 Ranking 4 Best 5 Increment 6 Decrement 7 Difference 8 Year to date 9 Rolling sum 10 Rolling average