Have you ever wanted to see how many times a value appears in the data, so you casually dropped the 'Value' dimension onto the rows panel of a pivot widget and the 'Count Value' measure onto the columns panel and get the value '1' for everything?
Then you scratched your head and said to yourself "hmm, this can't be right. I'm pretty sure I sold more than one Acer 2400 this month". Relax, you're not going out of business :-)
There are two ways to count values- counting distinct values and counting frequency of values.
If you right click the relevant dimension ('Product' in our case) and navigate to the Show/Hide Measures menu item, you will get the following options:
Count Product is the default and means counting distinct products. This measure is best used with dimensions other than the Product dimension. For example, if you want to know how many different products each one of your customers bought, this would be the measure to use.
Count Product (duplicates) means counting how many times each different product appeared. This measure is best used with the Product dimension, although it also has uses with others.
When you 'check' the measures in the menu, the corresponding measure will be visible under the Measures node in the Data Browser.
Using the Count Product (duplicates) measure will yield the results I wanted.
