I am learning Analytics Workbooks and Created a Pivot workbook.  I created a formula in the measures (calculated measure) for the sales order transaction lines (i.e. Qty(sum) * Rate(Max) ).  If I use the individual items in my rows, it shows the correct amount for each item.  When if I remove the items and try to get the summary by category, I get a much higher number.  For example, the lines for items in the Sale category total about $18K, but when I remove the items, the total for Sale category is $271K.  Obviously, the data is repeating, just cannot understand how.  Any advice is appreciated. Thank you! (edited)