Question:
Now I want to create a query,It has two column , the A column is monthly data,the B column is total data,Can you tell me how to do it.
Example:
month A B
200301 10 100
200302 20 100
200303 40 100
200304 10 100
200305 20 100
the B columns is the A columns's total.
_________________
Contact me: sapabap@hotmail.com
Answer:
Who can give me a solution?
_________________
Contact me: sapabap@hotmail.com
Answer:
You don't really say what type of help you are looking for - are you using the BEX? Column A is the monthly total? Column B is what? A grand total of all values, or a total of all time periods? And are you also drilling down by month? Do any of the different summarization techniques help? If not, you may need to use a result set query and variable to provide your totals.
_________________
Greg
Answer:
Example:The A Column is my monthly sales data,The B Column is my all months sales data total.
month A B
200212 10 100
200301 15 100
200302 15 100
200303 5 100
200304 5 100
200305 30 100
200306 20 100
total 100
if I drilldown it to dayly,then the result is
20021201 1 100
20031202 2 100
20031203 5 100
.... .. 100
20030304 1 100
Can you tell me how to do it?
thank you!
_________________
Contact me: sapabap@hotmail.com
Answer:
use function SUMGT for the second column (or SUMCT?)