Displaying %'s in a pivot table

[#1]

Is it possible?  I have a pivot table that details Month which expands to Date which then expands to Reason for Call... please see screenshot...l

I did have this originally set up as a straight table and was using the expression =sum(CallCounter) and selecting the Relative checkbox for the % column but I don't have the Relative option for a pivot table. We received a total of 149 calls on 03/08/2015... how can I get Accounts Payable to show 3.36%, Allocation - General to show 7.38% and so on?

Many thanks in advance.

[Colin-Albert · Accepted solution]

Try         sum(CallCounter) / sum(TOTAL CallCounter)

[alexandros17]

You must compute the percentage using aggr() function

[aveeeeeee7en]

Hi

Your Expression would be:

=(Sum(CallCounter)/Sum(TOTAL CallCounter))/100

Than Go To Number Tab >

Select this expression > Fixed to 1 Decimal > Check Show in Percent Box.

Regards

Av7eN

[#5]

As simple as that eh Colin?  Thanks so much for that