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! (edited) 

memariani Rookie Asked on January 14, 2023 in Other.
Add Comment
2 Answers


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.



Intermediate Answered on January 15, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.