2f:T664,baStyle = html``30:T42d,function cellFormatter() { return (x,i) => { const kpi = kpis[i] const revenue = SwitchButtons == 'Revenue'//(kpi.search("REVENUE") > -1) const quantity = SwitchButtons == 'Quantity'//(kpi.search("QUANTITY") > -1) const percent = (kpi.search("YoY Chg%") > -1) /* bidirectional means it can be positive but also negative */ const divider = percent? 100: 1 let format = "" if(percent) {format = "+,.1%"} //else if(percent && !bidirectional) {format = ",.1%"} //else if (!percent) {format = ".1f"} else if(revenue) { format = "~s"} else if(quantity) { format = ".9"} return htl.html`

${isNaN(x)? "": d3.format(format)( (x/divider) )}` } }31:T401,function cellFormatterSplit(colName) { return (x,i) => { const y = data_relatives[i][colName] const kpi_absolute = kpis_absolute[i] const kpi_relative = kpis_relative[i] let format_absolute = SwitchButtons == 'Revenue'? "~s": ".9" let format_relative = "+,.1%" return htl.html`

${isNaN(x)? "": d3.format(format_absolute)( (x) )}
${isNaN(y)? "": d3.format(format_relative)( (y/100) )}

` } }32:T1d52,dataMockDisplayr = ({"data":[{"Current Week":0,"Rolling 4 Weeks":95.64,"QTR":242.07,"YTD":6735.1199,"MAT":946.27,"_row":"REVENUE AV ACCESSORIES"},{"Current Week":-100,"Rolling 4 Weeks":-45.0029,"QTR":-61.0124,"YTD":137.1513,"MAT":-66.6808,"_row":"REVENUE AV ACCESSORIES YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":0,"QTR":116.52,"YTD":116.52,"MAT":116.52,"_row":"REVENUE CELLULAR PHONES"},{"Current Week":"NaN","Rolling 4 Weeks":"NaN","QTR":-30.8569,"YTD":-87.0958,"MAT":-87.0958,"_row":"REVENUE CELLULAR PHONES YoY Chg%"},{"Current Week":32714.7499,"Rolling 4 Weeks":141201.6003,"QTR":281932.4299,"YTD":1534857.9103,"MAT":1066859.6494,"_row":"REVENUE DISHWASHERS & WASTE DISPOSALS"},{"Current Week":223.115,"Rolling 4 Weeks":87.6219,"QTR":-6.3667,"YTD":79.0963,"MAT":24.4875,"_row":"REVENUE DISHWASHERS & WASTE DISPOSALS YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":0,"QTR":0,"YTD":0,"MAT":0,"_row":"REVENUE DVD & BLURAY HARDWARE"},{"Current Week":"NaN","Rolling 4 Weeks":"NaN","QTR":"NaN","YTD":"NaN","MAT":"NaN","_row":"REVENUE DVD & BLURAY HARDWARE YoY Chg%"},{"Current Week":30351.9605,"Rolling 4 Weeks":79988.8809,"QTR":227014.1619,"YTD":977340.2343,"MAT":699640.4227,"_row":"REVENUE HOME AUDIO"},{"Current Week":98.5908,"Rolling 4 Weeks":-14.1016,"QTR":5.4967,"YTD":90.5687,"MAT":36.4209,"_row":"REVENUE HOME AUDIO YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":2337.28,"QTR":6658.2501,"YTD":20182.4199,"MAT":17678.1398,"_row":"REVENUE IT ACCESSORIES"},{"Current Week":"NaN","Rolling 4 Weeks":-234.4609,"QTR":298.8122,"YTD":79.3378,"MAT":57.0851,"_row":"REVENUE IT ACCESSORIES YoY Chg%"},{"Current Week":137987.0001,"Rolling 4 Weeks":518388.4104,"QTR":1945542.8659,"YTD":6521301.9685,"MAT":4787524.4364,"_row":"REVENUE LAUNDRY"},{"Current Week":68.2027,"Rolling 4 Weeks":28.3483,"QTR":81.1933,"YTD":73.6742,"MAT":27.5005,"_row":"REVENUE LAUNDRY YoY Chg%"},{"Current Week":36557.629,"Rolling 4 Weeks":132229.7687,"QTR":238967.0901,"YTD":968663.0292,"MAT":818298.4946,"_row":"REVENUE MICROWAVE"},{"Current Week":55.6798,"Rolling 4 Weeks":58.4397,"QTR":11.3279,"YTD":35.4967,"MAT":14.4637,"_row":"REVENUE MICROWAVE YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":1389.5601,"QTR":7082.6,"YTD":55779.0701,"MAT":48410.2891,"_row":"REVENUE OCC Laundry"},{"Current Week":"NaN","Rolling 4 Weeks":"Inf","QTR":"Inf","YTD":"Inf","MAT":"Inf","_row":"REVENUE OCC Laundry YoY Chg%"},{"Current Week":1823.49,"Rolling 4 Weeks":4215.1401,"QTR":32073.6707,"YTD":171149.8306,"MAT":105657.6703,"_row":"REVENUE OCC Refrigeration"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":2362.2431,"YTD":145.7054,"MAT":51.6838,"_row":"REVENUE OCC Refrigeration YoY Chg%"},{"Current Week":164.35,"Rolling 4 Weeks":657.4,"QTR":10506.71,"YTD":19140.8203,"MAT":19140.8203,"_row":"REVENUE OCC Smalls"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":"Inf","YTD":"Inf","MAT":"Inf","_row":"REVENUE OCC Smalls YoY Chg%"},{"Current Week":3077.8899,"Rolling 4 Weeks":3077.8899,"QTR":120846.3828,"YTD":221938.4928,"MAT":191507.3604,"_row":"REVENUE OCC Television"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":138.3838,"YTD":189.1696,"MAT":149.5201,"_row":"REVENUE OCC Television YoY Chg%"},{"Current Week":215770.3293,"Rolling 4 Weeks":618988.85,"QTR":1851569.7642,"YTD":7070735.1534,"MAT":4927590.9914,"_row":"REVENUE REFRIGERATION"},{"Current Week":125.3886,"Rolling 4 Weeks":4.446,"QTR":28.3077,"YTD":91.3523,"MAT":33.3533,"_row":"REVENUE REFRIGERATION YoY Chg%"},{"Current Week":844274.8608,"Rolling 4 Weeks":1853693.9414,"QTR":5920661.6468,"YTD":23636217.8241,"MAT":15849496.1975,"_row":"REVENUE TELEVISION"},{"Current Week":62.0639,"Rolling 4 Weeks":-17.1516,"QTR":-11.3873,"YTD":55.3691,"MAT":4.1843,"_row":"REVENUE TELEVISION YoY Chg%"},{"Current Week":93714.5595,"Rolling 4 Weeks":237140.4685,"QTR":817330.7156,"YTD":2893124.4932,"MAT":2023372.5961,"_row":"REVENUE VACUUM CLEANERS"},{"Current Week":176.9847,"Rolling 4 Weeks":150.3967,"QTR":185.7447,"YTD":413.968,"MAT":259.4553,"_row":"REVENUE VACUUM CLEANERS YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":1,"QTR":3,"YTD":44,"MAT":7,"_row":"QUANTITY AV ACCESSORIES"},{"Current Week":-100,"Rolling 4 Weeks":-50,"QTR":-57.1429,"YTD":29.4118,"MAT":-79.4118,"_row":"QUANTITY AV ACCESSORIES YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":0,"QTR":2,"YTD":2,"MAT":2,"_row":"QUANTITY CELLULAR PHONES"},{"Current Week":"NaN","Rolling 4 Weeks":"NaN","QTR":-50,"YTD":-84.6154,"MAT":-84.6154,"_row":"QUANTITY CELLULAR PHONES YoY Chg%"},{"Current Week":32,"Rolling 4 Weeks":121,"QTR":233,"YTD":1280,"MAT":875,"_row":"QUANTITY DISHWASHERS & WASTE DISPOSALS"},{"Current Week":300,"Rolling 4 Weeks":86.1538,"QTR":2.193,"YTD":87.6833,"MAT":28.2991,"_row":"QUANTITY DISHWASHERS & WASTE DISPOSALS YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":0,"QTR":0,"YTD":0,"MAT":0,"_row":"QUANTITY DVD & BLURAY HARDWARE"},{"Current Week":"NaN","Rolling 4 Weeks":"NaN","QTR":"NaN","YTD":"NaN","MAT":"NaN","_row":"QUANTITY DVD & BLURAY HARDWARE YoY Chg%"},{"Current Week":65,"Rolling 4 Weeks":136,"QTR":493,"YTD":2238,"MAT":1541,"_row":"QUANTITY HOME AUDIO"},{"Current Week":75.6757,"Rolling 4 Weeks":-47.2868,"QTR":0,"YTD":72.0215,"MAT":18.4473,"_row":"QUANTITY HOME AUDIO YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":4,"QTR":5,"YTD":17,"MAT":14,"_row":"QUANTITY IT ACCESSORIES"},{"Current Week":"NaN","Rolling 4 Weeks":-500,"QTR":150,"YTD":112.5,"MAT":75,"_row":"QUANTITY IT ACCESSORIES YoY Chg%"},{"Current Week":127,"Rolling 4 Weeks":438,"QTR":1666,"YTD":5708,"MAT":4156,"_row":"QUANTITY LAUNDRY"},{"Current Week":54.878,"Rolling 4 Weeks":11.4504,"QTR":71.223,"YTD":72.5514,"MAT":25.6348,"_row":"QUANTITY LAUNDRY YoY Chg%"},{"Current Week":195,"Rolling 4 Weeks":581,"QTR":1087,"YTD":4264,"MAT":3567,"_row":"QUANTITY MICROWAVE"},{"Current Week":95,"Rolling 4 Weeks":70.3812,"QTR":4.5192,"YTD":33.6258,"MAT":11.7831,"_row":"QUANTITY MICROWAVE YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":2,"QTR":7,"YTD":62,"MAT":52,"_row":"QUANTITY OCC Laundry"},{"Current Week":"NaN","Rolling 4 Weeks":"Inf","QTR":"Inf","YTD":"Inf","MAT":"Inf","_row":"QUANTITY OCC Laundry YoY Chg%"},{"Current Week":3,"Rolling 4 Weeks":6,"QTR":38,"YTD":198,"MAT":128,"_row":"QUANTITY OCC Refrigeration"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":1800,"YTD":104.1237,"MAT":31.9588,"_row":"QUANTITY OCC Refrigeration YoY Chg%"},{"Current Week":1,"Rolling 4 Weeks":4,"QTR":67,"YTD":116,"MAT":116,"_row":"QUANTITY OCC Smalls"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":"Inf","YTD":"Inf","MAT":"Inf","_row":"QUANTITY OCC Smalls YoY Chg%"},{"Current Week":3,"Rolling 4 Weeks":3,"QTR":140,"YTD":265,"MAT":227,"_row":"QUANTITY OCC Television"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":211.1111,"YTD":248.6842,"MAT":198.6842,"_row":"QUANTITY OCC Television YoY Chg%"},{"Current Week":123,"Rolling 4 Weeks":350,"QTR":1063,"YTD":4148,"MAT":2769,"_row":"QUANTITY REFRIGERATION"},{"Current Week":98.3871,"Rolling 4 Weeks":-6.4171,"QTR":29.9511,"YTD":97.1483,"MAT":31.6065,"_row":"QUANTITY REFRIGERATION YoY Chg%"},{"Current Week":471,"Rolling 4 Weeks":1135,"QTR":3726,"YTD":14371,"MAT":9744,"_row":"QUANTITY TELEVISION"},{"Current Week":58.0537,"Rolling 4 Weeks":-6.1208,"QTR":-0.9306,"YTD":57.767,"MAT":6.9711,"_row":"QUANTITY TELEVISION YoY Chg%"},{"Current Week":108,"Rolling 4 Weeks":265,"QTR":952,"YTD":3504,"MAT":2378,"_row":"QUANTITY VACUUM CLEANERS"},{"Current Week":200,"Rolling 4 Weeks":154.8077,"QTR":220.5387,"YTD":488.9076,"MAT":299.6639,"_row":"QUANTITY VACUUM CLEANERS YoY Chg%"}]}) 33:[] 2d:{"title":"","cells":[{"id":341,"value":"Noel Leeming - Vendor KPIs > Category Leaderboard","pinned":false,"hidden":false,"mode":"md"},{"id":683,"value":"viewof SwitchButtons = Inputs.radio([\"Revenue\", \"Quantity\"], {label: \"Switch\", value: \"Revenue\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":560,"value":"mainDisplayrTable = html`

${forDisplayr}

`\n//now you're good\n//I would delete all the unnecessary / unused cells\n//otherwise will cause confusion \n//fully agree :) thanks! I have a depression from what I saw :)\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":200,"value":"forDisplayr = Inputs.table(\n data_absolutes,//DTU, \n {\n columns: columnToShow,\n rows: 30,\n format: tableFormatsSplit,\n align: tableColumnAlignments,\n layout: \"fixed\"\n}) \n\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":792,"value":"DTU = {\n let tempvar3 = dataToUse\n for (let i = 0; i < tempvar3.length; i++) {\n tempvar3[i].PG = tempvar3[i].PG.replace('REVENUE ','').replace('QUANTITY ','')\n } \n return tempvar3\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":832,"value":"data_absolutes = DTU.filter(o => o._row.indexOf(\"%\") == -1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":838,"value":"data_relatives = DTU.filter(o => o._row.indexOf(\"%\") > -1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":333,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":519,"value":"kpis = dataToUse.map(o => o[firstColRename])","pinned":false,"hidden":false,"mode":"ojs"},{"id":852,"value":"kpis_absolute = data_absolutes.map(o => o[firstColRename])","pinned":false,"hidden":false,"mode":"ojs"},{"id":847,"value":"kpis_relative = data_relatives.map(o => o[firstColRename])","pinned":false,"hidden":false,"mode":"ojs"},{"id":312,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":857,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":914,"value":"function col1FormtterSplit(colName) { \n return (x,i) => { \n const y = data_relatives[i][colName]\n \n return htl.html`

${(x)}
${y}

` \n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":321,"value":"\ntableFormats = Object.fromEntries(\n columnToShow.map((o) => {\n let pair = []\n if((o == firstColRename)) {\n pair = [o, x => x]\n }\n else {\n pair = [o, cellFormatter()] \n }\n return pair\n })\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":863,"value":"tableFormatsSplit = Object.fromEntries(\n columnToShow.map((o) => {\n let pair = []\n if((o == firstColRename)) {\n pair = [o, col1FormtterSplit(o)]\n }\n else {\n pair = [o, cellFormatterSplit(o)] \n }\n return pair\n })\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":491,"value":"tableColumnAlignments = Object.fromEntries(columnToShow.map( (o,i) => [o, i==0?\"left\":\"right\"] ))","pinned":false,"hidden":false,"mode":"ojs"},{"id":672,"value":"dataToUse = \n{\n let tempvar = dataToUse2\n if(SwitchButtons == 'Revenue') {\n tempvar = dataToUse2.filter(item => item._row.indexOf('REVENUE') > -1)\n } else if (SwitchButtons == \"Quantity\") {\n tempvar = dataToUse2.filter(item => item._row.indexOf('QUANTITY') > -1)\n } \n return tempvar\n}\n\n\n \n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":300,"value":"dataToUse2 = dataMockDisplayr.data.map(o => {\n const renamedObj = {} \n renamedObj[firstColRename] = o._row\n return {\n ...renamedObj,\n ...o\n }\n})\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":288,"value":"columnToShow = { \n let columnsAll = [firstColRename].concat(Object.keys(dataMockDisplayr.data[0])) //Add Brand\n columnsAll.splice(columnsAll.length - 1,1) ///get rid of _.row\n return columnsAll\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":419,"value":"firstColRename = \"PG\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":277,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}