topic Column wise Percentage in a pivot table in Getting Data In https://community.splunk.com/t5/Getting-Data-In/Column-wise-Percentage-in-a-pivot-table/m-p/544452#M90840 <P>I have pivoted my dataset to generate a table. The row and column header are auto generated based on attributes of dataset.&nbsp; My requirement is instead of each count, I want a percentage.</P><P>Search Query <span class="lia-unicode-emoji" title=":neutral_face:">😐</span> pivot Fill_Latency RootObject count(RootObject) AS "Fill Count" SPLITROW TradeDate AS TradeDate SPLITCOL DurationRangeSec SORT 100 TradeDate ROWSUMMARY 0 COLSUMMARY 0 NUMCOLS 100 SHOWOTHER 1</P><TABLE width="392"><TBODY><TR><TD width="98"><A href="http://secure-splunk-ist.ms.com/en-US/app/search/search?q=%7C%20pivot%20Fill_Latency%20RootObject%20count(RootObject)%20AS%20%22Fill%20Count%22%20SPLITROW%20TradeDate%20AS%20TradeDate%20SPLITCOL%20DurationRangeSec%20SORT%20100%20TradeDate%20ROWSUMMARY%200%20COLSUMMARY%200%20NUMCOLS%20100%20SHOWOTHER%201&amp;earliest=%40w0&amp;sid=1616139592.333592_C8BC385C-EADC-4FCD-9E4F-9A140BDFA613&amp;display.page.search.mode=verbose&amp;dispatch.sample_ratio=1&amp;latest=&amp;display.page.search.tab=statistics&amp;display.general.type=statistics" target="_blank" rel="noopener">Date</A></TD><TD width="98">RangeA</TD><TD width="98">RangeB</TD><TD width="98">RangeC</TD></TR><TR><TD width="98">19/02/2021</TD><TD width="98">425</TD><TD width="98">1195</TD><TD width="98">1584</TD></TR><TR><TD width="98">10/03/2021</TD><TD width="98">70</TD><TD width="98">0</TD><TD width="98">0</TD></TR><TR><TD width="98">17/03/2021</TD><TD width="98">28002</TD><TD width="98">35927</TD><TD width="98">9839</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expectation&gt;</P><TABLE width="353"><TBODY><TR><TD width="83"><A href="http://secure-splunk-ist.ms.com/en-US/app/search/search?q=%7C%20pivot%20Fill_Latency%20RootObject%20count(RootObject)%20AS%20%22Fill%20Count%22%20SPLITROW%20TradeDate%20AS%20TradeDate%20SPLITCOL%20DurationRangeSec%20SORT%20100%20TradeDate%20ROWSUMMARY%200%20COLSUMMARY%200%20NUMCOLS%20100%20SHOWOTHER%201&amp;earliest=%40w0&amp;sid=1616139592.333592_C8BC385C-EADC-4FCD-9E4F-9A140BDFA613&amp;display.page.search.mode=verbose&amp;dispatch.sample_ratio=1&amp;latest=&amp;display.page.search.tab=statistics&amp;display.general.type=statistics" target="_blank">Date</A></TD><TD width="90">RangeA</TD><TD width="90">RangeB</TD><TD width="90">RangeC</TD></TR><TR><TD width="83">19/02/2021</TD><TD width="90">13.2646692</TD><TD width="90">37.2971286</TD><TD width="90">49.4382022</TD></TR><TR><TD width="83">10/03/2021</TD><TD width="90">100</TD><TD width="90">0</TD><TD width="90">0</TD></TR><TR><TD width="83">17/03/2021</TD><TD width="90">37.9595489</TD><TD width="90">48.7026895</TD><TD width="90">13.3377616</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/15147">@somesoni2</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/163477">@tdhellma</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/184583">@Melstrathdee</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/172708">@martin_mueller</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/32490">@okrabbe</a>&nbsp;</P><P>&nbsp;</P> Fri, 19 Mar 2021 12:38:53 GMT vikbha 2021-03-19T12:38:53Z Column wise Percentage in a pivot table https://community.splunk.com/t5/Getting-Data-In/Column-wise-Percentage-in-a-pivot-table/m-p/544452#M90840 <P>I have pivoted my dataset to generate a table. The row and column header are auto generated based on attributes of dataset.&nbsp; My requirement is instead of each count, I want a percentage.</P><P>Search Query <span class="lia-unicode-emoji" title=":neutral_face:">😐</span> pivot Fill_Latency RootObject count(RootObject) AS "Fill Count" SPLITROW TradeDate AS TradeDate SPLITCOL DurationRangeSec SORT 100 TradeDate ROWSUMMARY 0 COLSUMMARY 0 NUMCOLS 100 SHOWOTHER 1</P><TABLE width="392"><TBODY><TR><TD width="98"><A href="http://secure-splunk-ist.ms.com/en-US/app/search/search?q=%7C%20pivot%20Fill_Latency%20RootObject%20count(RootObject)%20AS%20%22Fill%20Count%22%20SPLITROW%20TradeDate%20AS%20TradeDate%20SPLITCOL%20DurationRangeSec%20SORT%20100%20TradeDate%20ROWSUMMARY%200%20COLSUMMARY%200%20NUMCOLS%20100%20SHOWOTHER%201&amp;earliest=%40w0&amp;sid=1616139592.333592_C8BC385C-EADC-4FCD-9E4F-9A140BDFA613&amp;display.page.search.mode=verbose&amp;dispatch.sample_ratio=1&amp;latest=&amp;display.page.search.tab=statistics&amp;display.general.type=statistics" target="_blank" rel="noopener">Date</A></TD><TD width="98">RangeA</TD><TD width="98">RangeB</TD><TD width="98">RangeC</TD></TR><TR><TD width="98">19/02/2021</TD><TD width="98">425</TD><TD width="98">1195</TD><TD width="98">1584</TD></TR><TR><TD width="98">10/03/2021</TD><TD width="98">70</TD><TD width="98">0</TD><TD width="98">0</TD></TR><TR><TD width="98">17/03/2021</TD><TD width="98">28002</TD><TD width="98">35927</TD><TD width="98">9839</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expectation&gt;</P><TABLE width="353"><TBODY><TR><TD width="83"><A href="http://secure-splunk-ist.ms.com/en-US/app/search/search?q=%7C%20pivot%20Fill_Latency%20RootObject%20count(RootObject)%20AS%20%22Fill%20Count%22%20SPLITROW%20TradeDate%20AS%20TradeDate%20SPLITCOL%20DurationRangeSec%20SORT%20100%20TradeDate%20ROWSUMMARY%200%20COLSUMMARY%200%20NUMCOLS%20100%20SHOWOTHER%201&amp;earliest=%40w0&amp;sid=1616139592.333592_C8BC385C-EADC-4FCD-9E4F-9A140BDFA613&amp;display.page.search.mode=verbose&amp;dispatch.sample_ratio=1&amp;latest=&amp;display.page.search.tab=statistics&amp;display.general.type=statistics" target="_blank">Date</A></TD><TD width="90">RangeA</TD><TD width="90">RangeB</TD><TD width="90">RangeC</TD></TR><TR><TD width="83">19/02/2021</TD><TD width="90">13.2646692</TD><TD width="90">37.2971286</TD><TD width="90">49.4382022</TD></TR><TR><TD width="83">10/03/2021</TD><TD width="90">100</TD><TD width="90">0</TD><TD width="90">0</TD></TR><TR><TD width="83">17/03/2021</TD><TD width="90">37.9595489</TD><TD width="90">48.7026895</TD><TD width="90">13.3377616</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/15147">@somesoni2</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/163477">@tdhellma</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/184583">@Melstrathdee</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/172708">@martin_mueller</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/32490">@okrabbe</a>&nbsp;</P><P>&nbsp;</P> Fri, 19 Mar 2021 12:38:53 GMT https://community.splunk.com/t5/Getting-Data-In/Column-wise-Percentage-in-a-pivot-table/m-p/544452#M90840 vikbha 2021-03-19T12:38:53Z