Hi,
can anyone suggest the for the query below:
I am using Go DataWarehouse(query) package.
Product line, Product type, Product name, Quantity columns.
calculated items:
mamimum and minimum
calculations used are:
maximum==>maximum(Quantity for Product name)
minimum==>minimum(Quantity for Product name)
Questions: There is a single product name(Eg:'Cannon Mule Carryall') . so max and min value of product name should be quantity value right?. But showing irrelevant results. Please tell why it is so?
Thanks,
Yogeswari.
Hi,
There are potentially many detail records for each product name - a product may have many individual orders. The expressions above are returning the largest and smallest individual sale quantities for each product. Why do you think the results are irrelevant?
Cheers!
MF.
Hi,
i understand your point now. Quantity is the measure column. so it shows the aggregated value. Also since "for" scope is given for product name, it takes up the detailed level of data. If "for" scope is given for product line, it would have taken summarized level of data. Am i correct?
thanks,
yogeswari.
Yes - correct. The initial expressions you included are also returning a summarized level of data too - summarized for each product. The "for" clause determines which summarized level you are employing for the aggregation.
MF.