I am with QV for sometime now, but not really was a VB guy in the past, so I have a big problem, writing complex macros.. My clients requirement is something like, the ability to build Custom Aggregates... as in they can select the dimensions which shows the numbers, but they want something like when clicked on Multiply or Add or Divide, they need the numbers to be calculated... and they want his comparision with different hierarchies at the dimension level.