sharpapproach
asked on
Excel 2010 --> Pivot Table "Distinct" value needed
We have a query that we need the "distinct" value count.
On the attached screenshot, you will see per week we need a count of locations that ordered. not the "# of orders".
For example, Fort Bragg Honeycutt Shoppette has 2 orders for the week of 12/2/2013. We want to only have it count "1" because they ordered.
I have found that there is an add-on, but we are not permitted to install on the Company's Terminal Server.
Thank you for your assistance!
pivot-screenshot.jpg
On the attached screenshot, you will see per week we need a count of locations that ordered. not the "# of orders".
For example, Fort Bragg Honeycutt Shoppette has 2 orders for the week of 12/2/2013. We want to only have it count "1" because they ordered.
I have found that there is an add-on, but we are not permitted to install on the Company's Terminal Server.
Thank you for your assistance!
pivot-screenshot.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
{=MAX(IF(C2=$C$2:$C$100,IF