getting wrong calc in the Totals for the Pivot table?

[#1]

HI All,

In this report, I am having sales, target, call avg, % Ach , closing ..

% Ach will be always sales divided by target which i am having already calculated value, but in total also it should come total sales divide by the target,

but was showing sum of % Ach which is wrong it should show as 0.85..

Also for the call avg, but in the total it was showing sum, i need to get the avg of the calls is 59..

And for the closing it should come as the Last Month closing means feb Month in the Total as 75.

Month Selection will be the From Month as Jan & To Month as Feb..

For Sales & Target it getting total its correct..

How can i achieve Call avg & %ach in the Total...

Kindly help me on this..

Regards,

Helen

[#2]

HI Gysbert,

I have updated the above excel which is attached, included SalesType as Flag.

If it is Primary flag then Primary related type names,

If it is Primary & Seconadry flag then Seconadry ,Primary related type names,

Regards,

helen

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[#4]

Thanks Gysbert