aggregation or sum

[qaz56]

Hi,
in my crosstab i have column with number and precentage like

              quantity   cal1    % of X
product1  3000      14    40%
product2  2000      4      20%
sum         5000      18    60%

problem is in sum row. When used aggregation is SUM quantity and cal1 is ok, but % not.
When used aggregation is AGRETATE then % is ok, quantity and cal1 not (sum row display first value from column).

How avoid that?

[MDXpressor]

You can override the contents of any cell in your list.  With the cell for  sum% selected, go to the properties pane under the General section and change define contents to 'Yes'.  Then you can drop in any calculation you want.

[AnalyticsWithJay]

When you set it to AGGREGATE, you are telling it to use whatever property is set in the cube/model.

Try the following aggregates:
Quantity: Sum
Calc1: If this is a calculation, set it to 'Calculated', otherwise set it to Sum based on your post.
%: Calculated

If you're still having issues, try assigning Solve Order in case your order of calculations is impacting the logic. You can assign any number. Just make sure Quantity is first, then Calc1, then %.