Dear All
I extracted website data for a specified time period from Tool1 & Tool2 and try to compare date wise report between two tools Via Pivot table. But the date format is not matching between the tool even though the date format is same (YYYYMMDD) 20190201. How to sync the dates of different tools in Pivot table. Pls. find attached the excel sheet with pivot table for your kind reference. I am unable to attach the excel. That is the reason i pasted the pivot table here. Pls. Help
[TABLE="width: 2551"]
<colgroup><col><col><col span="37"></colgroup><tbody>[TR]
[TD]Row Labels[/TD]
[TD="align: right"]20190201[/TD]
[TD="align: right"]20190202[/TD]
[TD="align: right"]20190203[/TD]
[TD="align: right"]20190204[/TD]
[TD="align: right"]20190205[/TD]
[TD="align: right"]20190206[/TD]
[TD="align: right"]20190207[/TD]
[TD="align: right"]20190208[/TD]
[TD="align: right"]20190209[/TD]
[TD="align: right"]20190210[/TD]
[TD="align: right"]20190211[/TD]
[TD="align: right"]20190212[/TD]
[TD="align: right"]20190213[/TD]
[TD="align: right"]20190214[/TD]
[TD="align: right"]20190215[/TD]
[TD="align: right"]20190216[/TD]
[TD="align: right"]20190217[/TD]
[TD="align: right"]20190218[/TD]
[TD="align: right"]20190219[/TD]
[TD="align: right"]20190301[/TD]
[TD="align: right"]20190302[/TD]
[TD="align: right"]20190303[/TD]
[TD="align: right"]20190304[/TD]
[TD="align: right"]20190305[/TD]
[TD="align: right"]20190306[/TD]
[TD="align: right"]20190307[/TD]
[TD="align: right"]20190308[/TD]
[TD="align: right"]20190309[/TD]
[TD="align: right"]20190310[/TD]
[TD="align: right"]20190311[/TD]
[TD="align: right"]20190312[/TD]
[TD="align: right"]20190313[/TD]
[TD="align: right"]20190314[/TD]
[TD="align: right"]20190315[/TD]
[TD="align: right"]20190316[/TD]
[TD="align: right"]20190317[/TD]
[TD="align: right"]20190318[/TD]
[TD="align: right"]20190319[/TD]
[/TR]
[TR]
[TD]Website1[/TD]
[TD="align: right"]771[/TD]
[TD="align: right"]704[/TD]
[TD="align: right"]663[/TD]
[TD="align: right"]630[/TD]
[TD="align: right"]615[/TD]
[TD="align: right"]668[/TD]
[TD="align: right"]596[/TD]
[TD="align: right"]1064[/TD]
[TD="align: right"]1174[/TD]
[TD="align: right"]1313[/TD]
[TD="align: right"]1568[/TD]
[TD="align: right"]1346[/TD]
[TD="align: right"]1506[/TD]
[TD="align: right"]2148[/TD]
[TD="align: right"]1711[/TD]
[TD="align: right"]1619[/TD]
[TD="align: right"]1732[/TD]
[TD="align: right"]1776[/TD]
[TD="align: right"]1634[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]1176[/TD]
[TD="align: right"]1412[/TD]
[TD="align: right"]1217[/TD]
[TD="align: right"]1403[/TD]
[TD="align: right"]1419[/TD]
[TD="align: right"]1338[/TD]
[TD="align: right"]1260[/TD]
[TD="align: right"]1305[/TD]
[TD="align: right"]1227[/TD]
[TD="align: right"]1425[/TD]
[TD="align: right"]1424[/TD]
[TD="align: right"]1267[/TD]
[TD="align: right"]1296[/TD]
[TD="align: right"]1083[/TD]
[TD="align: right"]1312[/TD]
[TD="align: right"]1290[/TD]
[TD="align: right"]1332[/TD]
[TD="align: right"]1446[/TD]
[/TR]
[TR]
[TD]Tool1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]1176[/TD]
[TD="align: right"]1412[/TD]
[TD="align: right"]1217[/TD]
[TD="align: right"]1403[/TD]
[TD="align: right"]1419[/TD]
[TD="align: right"]1338[/TD]
[TD="align: right"]1260[/TD]
[TD="align: right"]1305[/TD]
[TD="align: right"]1227[/TD]
[TD="align: right"]1425[/TD]
[TD="align: right"]1424[/TD]
[TD="align: right"]1267[/TD]
[TD="align: right"]1296[/TD]
[TD="align: right"]1083[/TD]
[TD="align: right"]1312[/TD]
[TD="align: right"]1290[/TD]
[TD="align: right"]1332[/TD]
[TD="align: right"]1446[/TD]
[/TR]
[TR]
[TD]Tool2[/TD]
[TD="align: right"]771[/TD]
[TD="align: right"]704[/TD]
[TD="align: right"]663[/TD]
[TD="align: right"]630[/TD]
[TD="align: right"]615[/TD]
[TD="align: right"]668[/TD]
[TD="align: right"]596[/TD]
[TD="align: right"]1064[/TD]
[TD="align: right"]1174[/TD]
[TD="align: right"]1313[/TD]
[TD="align: right"]1568[/TD]
[TD="align: right"]1346[/TD]
[TD="align: right"]1506[/TD]
[TD="align: right"]2148[/TD]
[TD="align: right"]1711[/TD]
[TD="align: right"]1619[/TD]
[TD="align: right"]1732[/TD]
[TD="align: right"]1776[/TD]
[TD="align: right"]1634[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]771[/TD]
[TD="align: right"]704[/TD]
[TD="align: right"]663[/TD]
[TD="align: right"]630[/TD]
[TD="align: right"]615[/TD]
[TD="align: right"]668[/TD]
[TD="align: right"]596[/TD]
[TD="align: right"]1064[/TD]
[TD="align: right"]1174[/TD]
[TD="align: right"]1313[/TD]
[TD="align: right"]1568[/TD]
[TD="align: right"]1346[/TD]
[TD="align: right"]1506[/TD]
[TD="align: right"]2148[/TD]
[TD="align: right"]1711[/TD]
[TD="align: right"]1619[/TD]
[TD="align: right"]1732[/TD]
[TD="align: right"]1776[/TD]
[TD="align: right"]1634[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]1176[/TD]
[TD="align: right"]1412[/TD]
[TD="align: right"]1217[/TD]
[TD="align: right"]1403[/TD]
[TD="align: right"]1419[/TD]
[TD="align: right"]1338[/TD]
[TD="align: right"]1260[/TD]
[TD="align: right"]1305[/TD]
[TD="align: right"]1227[/TD]
[TD="align: right"]1425[/TD]
[TD="align: right"]1424[/TD]
[TD="align: right"]1267[/TD]
[TD="align: right"]1296[/TD]
[TD="align: right"]1083[/TD]
[TD="align: right"]1312[/TD]
[TD="align: right"]1290[/TD]
[TD="align: right"]1332[/TD]
[TD="align: right"]1446[/TD]
[/TR]
</tbody>[/TABLE]
I extracted website data for a specified time period from Tool1 & Tool2 and try to compare date wise report between two tools Via Pivot table. But the date format is not matching between the tool even though the date format is same (YYYYMMDD) 20190201. How to sync the dates of different tools in Pivot table. Pls. find attached the excel sheet with pivot table for your kind reference. I am unable to attach the excel. That is the reason i pasted the pivot table here. Pls. Help
[TABLE="width: 2551"]
<colgroup><col><col><col span="37"></colgroup><tbody>[TR]
[TD]Row Labels[/TD]
[TD="align: right"]20190201[/TD]
[TD="align: right"]20190202[/TD]
[TD="align: right"]20190203[/TD]
[TD="align: right"]20190204[/TD]
[TD="align: right"]20190205[/TD]
[TD="align: right"]20190206[/TD]
[TD="align: right"]20190207[/TD]
[TD="align: right"]20190208[/TD]
[TD="align: right"]20190209[/TD]
[TD="align: right"]20190210[/TD]
[TD="align: right"]20190211[/TD]
[TD="align: right"]20190212[/TD]
[TD="align: right"]20190213[/TD]
[TD="align: right"]20190214[/TD]
[TD="align: right"]20190215[/TD]
[TD="align: right"]20190216[/TD]
[TD="align: right"]20190217[/TD]
[TD="align: right"]20190218[/TD]
[TD="align: right"]20190219[/TD]
[TD="align: right"]20190301[/TD]
[TD="align: right"]20190302[/TD]
[TD="align: right"]20190303[/TD]
[TD="align: right"]20190304[/TD]
[TD="align: right"]20190305[/TD]
[TD="align: right"]20190306[/TD]
[TD="align: right"]20190307[/TD]
[TD="align: right"]20190308[/TD]
[TD="align: right"]20190309[/TD]
[TD="align: right"]20190310[/TD]
[TD="align: right"]20190311[/TD]
[TD="align: right"]20190312[/TD]
[TD="align: right"]20190313[/TD]
[TD="align: right"]20190314[/TD]
[TD="align: right"]20190315[/TD]
[TD="align: right"]20190316[/TD]
[TD="align: right"]20190317[/TD]
[TD="align: right"]20190318[/TD]
[TD="align: right"]20190319[/TD]
[/TR]
[TR]
[TD]Website1[/TD]
[TD="align: right"]771[/TD]
[TD="align: right"]704[/TD]
[TD="align: right"]663[/TD]
[TD="align: right"]630[/TD]
[TD="align: right"]615[/TD]
[TD="align: right"]668[/TD]
[TD="align: right"]596[/TD]
[TD="align: right"]1064[/TD]
[TD="align: right"]1174[/TD]
[TD="align: right"]1313[/TD]
[TD="align: right"]1568[/TD]
[TD="align: right"]1346[/TD]
[TD="align: right"]1506[/TD]
[TD="align: right"]2148[/TD]
[TD="align: right"]1711[/TD]
[TD="align: right"]1619[/TD]
[TD="align: right"]1732[/TD]
[TD="align: right"]1776[/TD]
[TD="align: right"]1634[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]1176[/TD]
[TD="align: right"]1412[/TD]
[TD="align: right"]1217[/TD]
[TD="align: right"]1403[/TD]
[TD="align: right"]1419[/TD]
[TD="align: right"]1338[/TD]
[TD="align: right"]1260[/TD]
[TD="align: right"]1305[/TD]
[TD="align: right"]1227[/TD]
[TD="align: right"]1425[/TD]
[TD="align: right"]1424[/TD]
[TD="align: right"]1267[/TD]
[TD="align: right"]1296[/TD]
[TD="align: right"]1083[/TD]
[TD="align: right"]1312[/TD]
[TD="align: right"]1290[/TD]
[TD="align: right"]1332[/TD]
[TD="align: right"]1446[/TD]
[/TR]
[TR]
[TD]Tool1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]1176[/TD]
[TD="align: right"]1412[/TD]
[TD="align: right"]1217[/TD]
[TD="align: right"]1403[/TD]
[TD="align: right"]1419[/TD]
[TD="align: right"]1338[/TD]
[TD="align: right"]1260[/TD]
[TD="align: right"]1305[/TD]
[TD="align: right"]1227[/TD]
[TD="align: right"]1425[/TD]
[TD="align: right"]1424[/TD]
[TD="align: right"]1267[/TD]
[TD="align: right"]1296[/TD]
[TD="align: right"]1083[/TD]
[TD="align: right"]1312[/TD]
[TD="align: right"]1290[/TD]
[TD="align: right"]1332[/TD]
[TD="align: right"]1446[/TD]
[/TR]
[TR]
[TD]Tool2[/TD]
[TD="align: right"]771[/TD]
[TD="align: right"]704[/TD]
[TD="align: right"]663[/TD]
[TD="align: right"]630[/TD]
[TD="align: right"]615[/TD]
[TD="align: right"]668[/TD]
[TD="align: right"]596[/TD]
[TD="align: right"]1064[/TD]
[TD="align: right"]1174[/TD]
[TD="align: right"]1313[/TD]
[TD="align: right"]1568[/TD]
[TD="align: right"]1346[/TD]
[TD="align: right"]1506[/TD]
[TD="align: right"]2148[/TD]
[TD="align: right"]1711[/TD]
[TD="align: right"]1619[/TD]
[TD="align: right"]1732[/TD]
[TD="align: right"]1776[/TD]
[TD="align: right"]1634[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]771[/TD]
[TD="align: right"]704[/TD]
[TD="align: right"]663[/TD]
[TD="align: right"]630[/TD]
[TD="align: right"]615[/TD]
[TD="align: right"]668[/TD]
[TD="align: right"]596[/TD]
[TD="align: right"]1064[/TD]
[TD="align: right"]1174[/TD]
[TD="align: right"]1313[/TD]
[TD="align: right"]1568[/TD]
[TD="align: right"]1346[/TD]
[TD="align: right"]1506[/TD]
[TD="align: right"]2148[/TD]
[TD="align: right"]1711[/TD]
[TD="align: right"]1619[/TD]
[TD="align: right"]1732[/TD]
[TD="align: right"]1776[/TD]
[TD="align: right"]1634[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]1176[/TD]
[TD="align: right"]1412[/TD]
[TD="align: right"]1217[/TD]
[TD="align: right"]1403[/TD]
[TD="align: right"]1419[/TD]
[TD="align: right"]1338[/TD]
[TD="align: right"]1260[/TD]
[TD="align: right"]1305[/TD]
[TD="align: right"]1227[/TD]
[TD="align: right"]1425[/TD]
[TD="align: right"]1424[/TD]
[TD="align: right"]1267[/TD]
[TD="align: right"]1296[/TD]
[TD="align: right"]1083[/TD]
[TD="align: right"]1312[/TD]
[TD="align: right"]1290[/TD]
[TD="align: right"]1332[/TD]
[TD="align: right"]1446[/TD]
[/TR]
</tbody>[/TABLE]