Skip to Content
Former Member
Jan 25, 2006 at 07:38 PM

Query Design


Dear All,

I have a requirement where I have to calculate the Sales amount for each material and then divide this amount by the total sales amount.

Now the total sales amount depends on the selection criterion and is not fixed. So my question is how would I find out amt / sum (amt) when neither the position of the total (the result row) can keep on changing and so can the position of the amt column, depending on the user drill down/across selection.

Any inputs would be appreciated.