Created calculated pivot field for unique "order numbers"

**michellepace** · 03-02-2018, 03:58 AM

Hi there,

Does anybody know what formula I could use in order to count the unique number of order numbers per row?

Basically I need my pivot table to calculate what I have written manually in green.
.
How to calculate unique orders.png

Work book attached.

Thanks in advance,
Michelle

**michellepace** · 03-02-2018, 04:09 AM

No to worry - I found the solution under "Count unique values in pivot table with helper column in Excel 2007/2010" in https://www.extendoffice.com/documen...ue-values.html

**xlnitwit** · 03-02-2018, 05:03 AM

Hi,

If your data is in the Data Model, there is a distinct count function available to you without using a helper column.

Created calculated pivot field for unique "order numbers"

LinkBack

Thread Tools

Rate This Thread

Display

Created calculated pivot field for unique "order numbers"

Re: Created calculated pivot field for unique "order numbers"

Re: Created calculated pivot field for unique "order numbers"

Thread Information

Users Browsing this Thread

Similar Threads

Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!

Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!

Remove the first and last group in the pivot field that starts with character ">" and "<"

Pivot Table calculated field to count if issue "needs follow up"

Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"

A function to change "text" to "numbers" so the result can be calculated.

Pivot Tables - How can I "reset" the selections in "Row Field"?

Bookmarks

Bookmarks

Posting Permissions