I have excel 2010 and I am trying to do the following (the table below has been done manually)
Customer Order type Revenue Sum 001 Pears 50 001 Plums 70 001 Strawberries 10 130 002 Pears 10 002 Strawberries 20 30 003 Pears 30 003 Plums 10 003 Strawberries 10 50
Basically I have data from the first 3 columns and I want to have an aggregate value in the fourth column for every customer: that is sum all the revenue from customer xxx
This should have been done by the BI too, I use, however I have not enough privileges to work this out with the appropriate sql queries
I have to do this for thousands of records, any idea about which function can make it? This is an interesting topic for anyone dealing with revenue reports.
RESOLUTION: I tried the formula suggested by Santosh, it works pretty well. You get the sum only once, then you just do some basic manipulations and you can get one row woth the total revenue per customer which is what I was looking for.