I am stuck with a pivot table. In my data I have taken two dimensions one is Customer Name in the ROW field of Pivot and other is Item Group in Column field and Measure is sum(invoice_Qty). I am getting repeated values as that of sum corresponding to each customer.
Can some please suggest why am I not getting the actual values of Invoice corresponding the customers.
Please have look at the attached screen shot that will make my question more Clear.