How to Calculate Total of Individual Cell to Overall Result.
I have Created Bex Query For Reporting In that Created 12 Selection's i.e jan.feb.....dec for Calculating total Individual Months based on vendor's and Calculating Total of all 12 months And I am Calculating Avg for Total of individual vendor of all months to overall result I am Getting Wrong Result,Here I have tried with %ct,%gt and %rt all functions showing Same % Avg.In screen I have highlighted two cells first one is total of vendor for 12 months last one total of all vendors for 12 months if I am calculating %avg manually i.e((3926/10835)= 36.23) but I am getting 20.89 this one is wrong how can I get Desire result.
Loed Despuig replied
We can use replacement path in QUERY..
You need to create two (2) queries..1st query is the query you are using right now..Create 2nd query and filter it in the FILTER tab with vendor with replacement path in query (choose the 1st query)..
The 2nd query will give you the result of the top 10 vendors and you can use any of the suggested solutions here like the one I have said:
AVERAGE = ( TOTAL / SUMGT(TOTAL) ) %A 1