RE: 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!
I wonder whether you might be getting the header line here? If you filter by item then it will exclude the header since there’s no item on the header.
Perhaps try Mainline = False in the filters.