Calculations in pivot tables

New Contributor



I'm having problems doing calculation with functions in a pivot table.


For example, '=SUMIF(range, criteria) / COUNTIF(range, criteria)' would only return the sum of a range sorted with the criteria, it would not take into consideration  the '/' operator and the rest function. (it works in google sheets)

I had to do this manually and separately which took more time.


2 Replies

depends on platform you use, in general creating PivotTable it's better to add data to data model and use DAX measures.

@Sergei Baklan 

I have no idea what data on data and DAX measures are, but I'll take a look into them! thanks.