![]() In earlier versions, you can use SUMPRODUCT to create a unique count formula. In the screen shot below, I used the COUNTIFS function, which is available in Excel 2007, and later versions. ![]() So, the result is really a count of the orders, not a count of the unique stores.Īs a workaround, you can add a column to the pivot table source data, and use a formula to calculate one or zero in each row. Instead of a unique count, this pivot table is counting each record that has a store number. In the pivot table shown below, we’d like to see the number of stores in Boston, where each product category was sold. In Excel 2010, there is no built-in summary function that calculates a distinct count or unique count in a pivot table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |