Create two computed field based on table calculation function
ZN(COUNT([Sales]) / TOTAL(COUNT([Sales])))
which on ship mode table across
Sales Percent Diff
ZN([Sales Percent]) - LOOKUP(ZN([Sales Percent]), -1)
which on table along
attached twbx shows that ...
Can u send the Viz to review ....
I can't as the data is confidential. Any way that I can anonymous the data???
I believe as it working with the sample it must work with the real data, you can change the field names, and remove the unnecessary column from the data source this will hide the confidentiality, you can also remove part of the data ...