1

i have thise DATA BASE DATA BASE

The column E is a helper to the calculation for the column F which allows us to calculate how much type(chap) handled a month , the formulas are showing in red.

i creat form this data base this pivot table , and wath i need is row that calculate count (resp) / average (NB type a month) that's mean (row 1) / (row 2) in french (Nombre de RESP)/(Moyenne de NB type a month) . this is the pivot table

As you can see i creat a calculated feild that typically can do this but it's give me wrong aswer :

this is the calculted feild

i wish a can amend or add helper column in my data base to acheive wath i need or get the rigth formula , i want to do that in pivot table please .

thanks a lot for your answers ....

H.hisoka
  • 61
  • 9
  • It seems to me that this is your problem: https://support.microsoft.com/en-us/kb/211470 – Ralph May 03 '16 at 09:45
  • You can't do that in a regular pivot table (the calculated field will always sum). Do you have Power Pivot? – Rory May 03 '16 at 09:51
  • i think it possible with calclated field (sum) , but i have to add helper column in my data base , this is an exmple : [link ](http://stackoverflow.com/questions/12402177/pivot-calculated-formula-sumfield1-avgfield2). i didn't undertand the solution – H.hisoka May 03 '16 at 11:47
  • i don't have Power pivot – H.hisoka May 03 '16 at 12:00

1 Answers1

0

i get the answer : the solution is to add a clumn to the data base , calculate how many "resp" each month , then insert it to the pivot tabale and do the ratio :) data base with helper

new pivot table with the right calculations

H.hisoka
  • 61
  • 9