Hello All,
I am having a bit of an issue putting together some DAX Formulae; this is something I can do in Excel but using Power Pivot and Power Query I am out of my comfort zone!
There are three columns in CAPS that I am trying to figure out in Power Pivot.
MIN TIME - this is using 'Time', 'UPC' and 'Store' and finding the minimum number
SUM ON UPC - this is finding a sum for each 'UPC' and 'Store'
ANNUALIZE - using a formula to annualize the data from the sum on UPC column (should be easy once I can calculate MIN TIME and SUM ON UPC
Thank you for the help!
[TABLE="width: 629"]
<tbody>[TR]
[TD="align: center"]UPC[/TD]
[TD="align: center"]Store[/TD]
[TD="align: center"]Bucket[/TD]
[TD="align: center"]Package[/TD]
[TD="align: center"]Time[/TD]
[TD="align: center"]Dollars[/TD]
[TD="align: center"]MIN TIME[/TD]
[TD="align: center"]SUM ON UPC[/TD]
[TD="align: center"]ANNUALIZE[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]201313[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]$308[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]$308[/TD]
[TD="align: center"]$445[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203320[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$35[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$143[/TD]
[TD="align: center"]$143[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203320[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$24[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$143[/TD]
[TD="align: center"]$143[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203320[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]$48[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$143[/TD]
[TD="align: center"]$143[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203320[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]$36[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$143[/TD]
[TD="align: center"]$143[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203330[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$36[/TD]
[TD="align: center"]$43[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203330[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$36[/TD]
[TD="align: center"]$43[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203330[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$36[/TD]
[TD="align: center"]$43[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203330[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]$78[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203361[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$49[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$86[/TD]
[TD="align: center"]$86[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203361[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$25[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$86[/TD]
[TD="align: center"]$86[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203361[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$86[/TD]
[TD="align: center"]$86[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$26[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$50[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]$60[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]$61[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]$24[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]$24[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]$24[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]$37[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203375[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$98[/TD]
[TD="align: center"]$106[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203375[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$98[/TD]
[TD="align: center"]$106[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203375[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]$24[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$98[/TD]
[TD="align: center"]$106[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203375[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]$25[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$98[/TD]
[TD="align: center"]$106[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203375[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]$25[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$98[/TD]
[TD="align: center"]$106[/TD]
[/TR]
</tbody>[/TABLE]
I am having a bit of an issue putting together some DAX Formulae; this is something I can do in Excel but using Power Pivot and Power Query I am out of my comfort zone!
There are three columns in CAPS that I am trying to figure out in Power Pivot.
MIN TIME - this is using 'Time', 'UPC' and 'Store' and finding the minimum number
SUM ON UPC - this is finding a sum for each 'UPC' and 'Store'
ANNUALIZE - using a formula to annualize the data from the sum on UPC column (should be easy once I can calculate MIN TIME and SUM ON UPC
Thank you for the help!
[TABLE="width: 629"]
<tbody>[TR]
[TD="align: center"]UPC[/TD]
[TD="align: center"]Store[/TD]
[TD="align: center"]Bucket[/TD]
[TD="align: center"]Package[/TD]
[TD="align: center"]Time[/TD]
[TD="align: center"]Dollars[/TD]
[TD="align: center"]MIN TIME[/TD]
[TD="align: center"]SUM ON UPC[/TD]
[TD="align: center"]ANNUALIZE[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]201313[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]$308[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]$308[/TD]
[TD="align: center"]$445[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203320[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$35[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$143[/TD]
[TD="align: center"]$143[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203320[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$24[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$143[/TD]
[TD="align: center"]$143[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203320[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]$48[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$143[/TD]
[TD="align: center"]$143[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203320[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]$36[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$143[/TD]
[TD="align: center"]$143[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203330[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$36[/TD]
[TD="align: center"]$43[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203330[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$36[/TD]
[TD="align: center"]$43[/TD]
[/TR]
[TR]
[TD="align: center"]108372[/TD]
[TD="align: center"]203330[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$36[/TD]
[TD="align: center"]$43[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203330[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]$78[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203361[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$49[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$86[/TD]
[TD="align: center"]$86[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203361[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$25[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$86[/TD]
[TD="align: center"]$86[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203361[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$86[/TD]
[TD="align: center"]$86[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$26[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$50[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]$60[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]$61[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]$24[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]$24[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]$24[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]$37[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203363[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]$354[/TD]
[TD="align: center"]$354[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203375[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$98[/TD]
[TD="align: center"]$106[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203375[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]$12[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$98[/TD]
[TD="align: center"]$106[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203375[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]$24[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$98[/TD]
[TD="align: center"]$106[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203375[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]$25[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$98[/TD]
[TD="align: center"]$106[/TD]
[/TR]
[TR]
[TD="align: center"]100300[/TD]
[TD="align: center"]203375[/TD]
[TD="align: center"]DWF[/TD]
[TD="align: center"]MSC[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]$25[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]$98[/TD]
[TD="align: center"]$106[/TD]
[/TR]
</tbody>[/TABLE]
