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
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