contextoperators in bo 4.0(calculation context using sum)

30 Views

All,

I am using Webi 4.0 version.I have a scenario in my webi report wherei need to sum up revenue.i want to sum up the sales revenue generated by each employee for a store irrespective of the month.

What i mean is even if the months are different i want to sum the revenuebased on the branch and employee in column G.

My webi report looks pretty much like the below sample.I dont want to apply any breaks or sections,Can i achieve this using context operators or calculation context.

i have tried personally applying context opearators on totalevenue column by applying sum but its not summing up as in column g.

for ex: sum(revenue for each(branchcode))

i want to achieve the totals as shown in column totalrevenue(last column) without applying break or section.

Can any one helpme out.

*Branch>>>>Employee>>Store>>>>Region>>>>>>>Month>>>>>>Revenue>>>>>>TotalRevenue

*A>>>>>>>Dave>>>>>>>D>>>>>>>North>>>>>>>Jan-09>>>>>>>100$>>>>>>>>>

A>>>>>>>Dave>>>>>>>E>>>>>>>south>>>>>>>Jan-10>>>>>>>200$>>>>>>>>>>300$

B>>>>>>>Andrew>>>>>F>>>>>>>east>>>>>>>Feb-09>>>>>>>10000$>>>>>>>>

B>>>>>>>Andrew>>>>>G>>>>>>>west>>>>>>>Feb-10>>>>>>>100000$>>>>>>>110000$

Regards,

Reji.

Edited by: reji2011 on Dec 13, 2011 5:23 PM