Help me please
Why is the answer in the regular table not equal to the Pivot table?
This my code in Expression Pivot table
Excample Yarn item = CVC20/1R week 18
I wasn't able to understand what you're trying to do here.
You are comparing two different formulas. Why should they give the same result?
Additionally, you are using Sum(Distinct ...) which is almost always a bad idea since the same value might repeat multiple times.
There are various things noticeable. At first the distinct within the sum() like orsh_ hinted. Further the dimensions within the second table aren't the same like in the aggr and then it missed an outer aggregation.