I have pivoted my dataset to generate a table. The row and column header are auto generated based on attributes of dataset.  My requirement is instead of each count, I want a percentage. Search Query 😐 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 Date RangeA RangeB RangeC 19/02/2021 425 1195 1584 10/03/2021 70 0 0 17/03/2021 28002 35927 9839   Expectation> Date RangeA RangeB RangeC 19/02/2021 13.2646692 37.2971286 49.4382022 10/03/2021 100 0 0 17/03/2021 37.9595489 48.7026895 13.3377616   @somesoni2 @tdhellma @Melstrathdee @martin_mueller @okrabbe    ... View more