The relative percentage of OrderSalesAmount for a single value in a dimension field compared to the total of all other possible values in that field. alias as OrderSalesAmount %
this is the reqirement 1)(UnitPrice * Quantity) * (1-Discount) as LineSalesAmount this is order detail table
2)sum(LineSalesAmount ) as OrderSalesAmount this is order table
3)The relative percentage of OrderSalesAmount for a single value in a dimension field compared to the total of all other possible values in that field. alias as OrderSalesAmount %
and also i want this in order table first 2 i got ..can any one guide me how to write the script for the third one
