The value 38 getting populated because the calculation is restarting at the "Part Number" level.
Request you folks to help me on this.
Hi Parvinder, I'm happy to help you, but in the future please don't post a workbook with the Update paused. Thanks.
You are looking for an Advanced table calculation like this:
I've attached a 7.0 workbook.
PO_Report_test-SW.twbx.zip 93.2 KB
Yeah it's one of those Tableau quirks. Start with a brand new calculated field and then paste this in:
ZN(SUM([Variance])) - LOOKUP(ZN(SUM([Variance])), -1)
Now drop that on top of the quick table calculation you currently have. And then set the compute using the exact same as the png I posted. Now you'll have the Restart option.