When I put multiple dimensions on the y-axis of our Sales cube sheet a Total row automatically displays, is there a way to suppress this? The Total row does not make any sense.
There is not currently a way to suppress this system generated total. Here are a couple of workarounds you can try:
1. Display only one element on the y-axis at a time.
2. Add the accounts to an Account Group via the Cube Sheet Builder. When this is done the Total row will still appear, but the value will be blank.