How to change the expression for Total Field ?

[semsel]

I am using a crosstab report with rows having Item name and their Qty, Amount and Avg Price. In the coulmn I have fiscal year and monthname.. I applied the aggregate for the whole year which should give the total for quantities and amounts for all months for a particular item. I want the Avg Price should be displayed as Total (Amount) / Total (Quantity) instead of Total (Avg). How do I change this?

Please refer the screenshot to get an idea

[norkos]

Hi,

If the Avg Price item is a calculated data item or a claculated measure then you just need to change the solve order property of Avg Price to a greater number then you can see in same property of the Total item.

If Avg Price is a measure comes directly from the cube, then first you have to change it with a calculated one.

NoRkoS