Any way to add multiple value fields to a pivot table quicly?

[jonybandana]

Hi! So I have to add multiple items to the "value" field of a pivot table (about 50 items), and I do not have a quick way to do it! If I try to use the checkboes, then the item gets added to the "Columns" field. I could also drag them to the "value" field, but that also adds them as "Count" and I need to add them as "Sum".

Is there any way to add this quickly and not have to do all manually?

To better understand my problem, I'll attach this picture:

I need about 52 "Sum of X" in the "Value" field, and adding everything manually is incredibly annoying. Is there any way to make this easier?

 

[arthurbr]

Hi. there are some insights at the end of this page