Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
61
Views
Topic starter
Hello everybody,
In a Pivot Table I have different prices for the same product (discounts, promotions,...); With " Summarize field by" I have already calculated the average price, the minimum and maxime price , but I would like to have the most used price, is it possible? how could you use the mod.sngl formula in a pivot table?
Thanks
Miguel
Posted : 05/12/2019 12:00 pm
Hi Miguel,
PivotTables don't support the MODE.SNGL function, sorry. You'd need to do this calculation either outside of the PivotTable, or using Power Pivot and a DAX measure.
Mynda
Posted : 05/12/2019 7:01 pm
