1.0HR Letter Formatshttps://www.yourhrworld.com/formatsPivot Table - HR Letter Formatsrich600338<blockquote class="wp-embedded-content" data-secret="swUcOk7QLv"><a href="https://www.yourhrworld.com/formats/hr/pivot-table/">Pivot Table</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.yourhrworld.com/formats/hr/pivot-table/embed/#?secret=swUcOk7QLv" width="600" height="338" title="“Pivot Table” — HR Letter Formats" data-secret="swUcOk7QLv" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script>
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
//# sourceURL=https://www.yourhrworld.com/formats/wp-includes/js/wp-embed.min.js
</script>
Pivot Table is used to Fetch the Data according to our use or format as which column we need we can easily sort out, (Example – if the employee working for 12 hours daily and the total days he work for 15 days, the the total will come in last column, so to see only empid and total hour work, we can easily see through Pivot Table) Steps – 1, Select new sheet or existing, 2, Go to Insert Option 3, Select Pivot Table 4, Then the dialog box open with some formula’s type just click on ok, then one