Hello,
I have a query that displays a certain sums grouped by user_id :
select ms.user_id
, nvl(sum(ms.mon\_curr),0)
, nvl(sum(ms.mon\_prev),0)
from monsales ms
where ms.yyyy = :YEAR
and ms.mon = :MONTH
and ms.rep\_name = :REP\_NAME
group by ms.user_id
I built BI report and would like to show the total sum for my columns. I added a new line on the bottom and for each column, I inserted a field where I selected the sum Function:
and in the Advanced tab:
It is showing the total sum for each user_id and not the grand Total. How can I specify the total outside each group loop?
Thanks.