Pivot table sum of TAT/ count of items

[Apple Ling]

Hi,

I would like to have a calculated field in pivot table to calculate the percentage of (sum of TAT/ count of items). However, if I insert the formula in calculated field as
Count(ClaimNumber)/Sum(Curr_TAT), I will get value 1.

Name Count of ClaimNumber Sum of Curr_TAT % of TAT (Count of items/sum of tat)
XXX 6685 1 0.01%
YYY 6137 1 0.02%

Thanks,
Apple

[dflak]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[mahju]

May try this
in view field setting , under show values as select % of total

Regards

[Apple Ling]

Hi,

Sorry for the misalignment. I attached a sample workbook easy for reference.

Thanks,
Apple

[dflak]

The solution required playing with the source data. For some reason Excel doesn't recognize Count Of as a number in formulas. I added a column called Count and populated it with 1 for each cell. Then I used this in the formula =Days/Count.