Pivot Table: Calculated field option grayed out?

[roattw]

I have a pivot table using just basic totals - calculated values in the Sum area (thanks LittleMiss Ginger !)

Interestingly, I went o add one more and the option to add another calculated value is grayed out and wont open.  Does Caspio know I dont have another "countable" field to even apply a calc field to?  I added a random field like "email" and no calculated field option, and there was no Custom option under "Summarize values as" like there was in the other fields.

Fields allowing Calc Field+ and Custom option:

Field not allowing Cal Field+ and with no custom:

[cheonsa]

Hi @roattw,

If you select a field in the table, Custom option will not be available. It is present in Totals and Aggregation if you click on the plus button. Also, picker button is not available in Pivot Table. 

[roattw]

Wow, I always forget the obvious.  I didnt scroll down farther when I clicked the "+" sign to see Totals and Aggregates   Thanks - again!

[Elderberg]

Hi, i've selected Custom option using Totals and Aggregation..  how do I use the Custom option to do summation?