wrong total in Analytics Workbook calculated Measure
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!