Calculations in pivot tables

New Contributor

Hello,

 

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

@iydoag 
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.