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) 

Rookie Asked on January 14, 2023 in Other.
Add Comment
2 Answer(s)

Hi,

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.

Thanks,

Chris

Intermediate Answered on January 15, 2023.
Add Comment

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,

Michael

Rookie Answered on January 15, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor