i wonder is it possible to do this in pivot table?
As the title, i want to do these in the pivot:
- Show number of value as percentage of parent for the sub filter, while the parent filter still keep number format.
- Move the grand total to the first row.
- Calculate 2 more metric as %.
It would much easier to see my expect image here.
- Is actual pivot
- My expect pivot table would be
If necessary we can reorganize the data so that there is some way to do the above in the pivot table.
Your guidance to make the above work is greatly appreciated. Thank you so much.
Data here:
<!DOCTYPE html>
<html>
<style>
table, th, td {
border:1px solid black;
}
</style>
<body>
<h2>A basic HTML table</h2>
<table style="width:100%">
<tr>
<th>CREATE_DATE</th>
<th>STAGE</th>
<th>STATUS</th>
<th>COUNT(*)</th>
<tr>
<td>02-Sep</td>
<td>DE</td>
<td>REJECTED</td>
<td>2</td>
</tr>
<tr>
<td>03-Sep</td>
<td>DE</td>
<td>REJECTED</td>
<td>3</td>
</tr>
<tr>
<td>01-Sep</td>
<td>DC</td>
<td>REJECTED</td>
<td>4</td>
</tr>
<tr>
<td>02-Sep</td>
<td>DC</td>
<td>REJECTED</td>
<td>5</td>
</tr>
<tr>
<td>03-Sep</td>
<td>DC</td>
<td>REJECTED</td>
<td>6</td>
</tr>
<tr>
<td>01-Sep</td>
<td>ON SCREEN</td>
<td>REJECTED</td>
<td>7</td>
</tr>
<tr>
<td>02-Sep</td>
<td>ON SCREEN</td>
<td>REJECTED</td>
<td>8</td>
</tr>
<tr>
<td>03-Sep</td>
<td>ON SCREEN</td>
<td>REJECTED</td>
<td>9</td>
</tr>
<tr>
<td>01-Sep</td>
<td>DC</td>
<td>REJECTED</td>
<td>10</td>
</tr>
<tr>
<td>02-Sep</td>
<td>DE</td>
<td>REJECTED</td>
<td>11</td>
</tr>
<tr>
<td>03-Sep</td>
<td>ON SCREEN</td>
<td>REJECTED</td>
<td>12</td>
</tr>
<tr>
<td>01-Sep</td>
<td>DC</td>
<td>REJECTED</td>
<td>13</td>
</tr>
<tr>
<td>02-Sep</td>
<td>DE</td>
<td>REJECTED</td>
<td>14</td>
</tr>
<tr>
<td>03-Sep</td>
<td>ON SCREEN</td>
<td>REJECTED</td>
<td>1</td>
</tr>
<tr>
<td>01-Sep</td>
<td></td>
<td>APPROVED</td>
<td>2</td>
</tr>
<tr>
<td>02-Sep</td>
<td></td>
<td>APPROVED</td>
<td>3</td>
</tr>
<tr>
<td>03-Sep</td>
<td></td>
<td>APPROVED</td>
<td>4</td>
</tr>
<tr>
<td>01-Sep</td>
<td></td>
<td>APPROVED</td>
<td>5</td>
</tr>
<tr>
<td>02-Sep</td>
<td></td>
<td>APPROVED</td>
<td>6</td>
</tr>
<tr>
<td>03-Sep</td>
<td></td>
<td>APPROVED</td>
<td>7</td>
</tr>
<tr>
<td>01-Sep</td>
<td></td>
<td>APPROVED</td>
<td>8</td>
</tr>
<tr>
<td>02-Sep</td>
<td></td>
<td>APPROVED</td>
<td>9</td>
</tr>
<tr>
<td>03-Sep</td>
<td></td>
<td>APPROVED</td>
<td>10</td>
</tr>
<tr>
<td>01-Sep</td>
<td></td>
<td>APPROVED</td>
<td>11</td>
</tr>
<tr>
<td>02-Sep</td>
<td></td>
<td>APPROVED</td>
<td>12</td>
</tr>
<tr>
<td>03-Sep</td>
<td></td>
<td>APPROVED</td>
<td>13</td>
</tr>
<tr>
<td>01-Sep</td>
<td></td>
<td>APPROVED</td>
<td>14</td>
</tr>
</table>
<p>To undestand the example better, we have added borders to the table.</p>
</body>
</html>