Hi all i am currently building a cube in BIDS i have created a measure the measure represents the a column called Pounds/sterling for the cost of an order.
I am creating a dashboard that will show the average order value based on months i have created my Time dimension etc already all that is working fine, but cannot get the correct results when selecting the AVERAGE aggregation on the measure.
Not sure if i am doing something wrong here but when i add the measure i select the data type as Currency and the Aggregation as Average of Children.
i will give you an example of what i would expect to see for the month of September i have a query in SQL that shows All the orders for september and my measure is based on a column in that query called pound_sterling,
so i am creating the measure correctly if i want the average of all orders placed in september because the value i get is not correct