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?
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.
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 %.