Sum of- in Pivot

[ceejay01]

How to do sum of- in pivot? I have these datas:
impressions, clicks, cost,etc. I tried to drag the item to values section and it shows as "çount of".. I need it as sum..

Please help..

Thanks

 

[Jerry Sullivan]

Here are steps to change the type of summary...

Click on the Field in the PivotTable Field list > Value Field Settings > Summarize Values By > Sum

 

[powerpivotpro]

You will get a count instead of a sum if the underlying column is text rather than numeric.

Go back to the PowerPivot window, and on the ribbon, change the Data Type. Then go back and re-add the field to the pivot.

 

[ceejay01]

You will get a count instead of a sum if the underlying column is text rather than numeric.

Go back to the PowerPivot window, and on the ribbon, change the Data Type. Then go back and re-add the field to the pivot.

Yes, already figure it out. Thanks to JS411

 

[Jerry Sullivan]

When I posted my suggestion, I didn't notice that this question was in the PowerPivot forum.
I haven't explored PowerPivot (yet).

Hopefully my suggestion was still applicable - please disregard if it isn't.