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

Thank you Chris.


The dataset has “Transaction Line: Mainline is false”, so that does not appear to be the problem.  I will keep tinkering.


Appreciate the advice,


Rookie Answered on January 15, 2023.
Add Comment

Your Answer

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