Mar 27 2022 11:17 AM
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.
Mar 27 2022 11:24 AM
@iydoag
depends on platform you use, in general creating PivotTable it's better to add data to data model and use DAX measures.
Mar 27 2022 01:17 PM
I have no idea what data on data and DAX measures are, but I'll take a look into them! thanks.