hi guys
I have to filter data in a Pivot Table that shows it in the following order:
Morning Shift
Afternoon Shift
Night Shift
Excel 2010<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px"><colgroup><col style="background-color: #DAE7F5" width="25px"><col><col><col><col><col><col><col></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th>
</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">43</td><td style=";">Row Labels</td><td style=";">Time To</td><td style=";">Total</td><td style=";">DelayOption</td><td style=";">Delay</td><td style=";">Responsibility</td><td style=";">ShiftOption</td></tr><tr><td style="color: #161120;text-align: center;">44</td><td style=";">23:45:00</td><td style=";">00:45:00</td><td style=";">60</td><td style=";">Mechanical breakdown</td><td style=";">Oversize conv set screw broken</td><td style=";">Engineering</td><td style=";">Night</td></tr><tr><td style="color: #161120;text-align: center;">45</td><td style=";">20:00:00</td><td style=";">22:00:00</td><td style=";">120</td><td style=";">Loader unavailable</td><td style=";">Dumptruck broken undebelt oversice </td><td style=";">KUM</td><td style=";">Afternoon</td></tr><tr><td style="color: #161120;text-align: center;">46</td><td style=";">15:47:00</td><td style=";">19:00:00</td><td style=";">193</td><td style=";">Mechanical breakdown</td><td style=";">Pan 2 Trommeldrive motor bolts broken</td><td style=";">Engineering</td><td style=";">Afternoon</td></tr><tr><td style="color: #161120;text-align: center;">47</td><td style=";">15:40:00</td><td style=";">19:45:00</td><td style=";">245</td><td style=";">Electrical</td><td style=";">Pan 1 Extractor trip and block</td><td style=";">Metallurgical</td><td style=";">Afternoon</td></tr><tr><td style="color: #161120;text-align: center;">48</td><td style=";">15:00:00</td><td style=";">15:30:00</td><td style=";">30</td><td style=";">Mechanical breakdown</td><td style=";">Change porrelpump motor</td><td style=";">Engineering</td><td style=";">Afternoon</td></tr><tr><td style="color: #161120;text-align: center;">49</td><td style=";">14:00:00</td><td style=";">15:00:00</td><td style=";">60</td><td style=";">Chokes</td><td style=";">Concentrate line block</td><td style=";">Metallurgical</td><td style=";">Afternoon</td></tr><tr><td style="color: #161120;text-align: center;">50</td><td style=";">12:16:00</td><td style=";">13:00:00</td><td style=";">44</td><td style=";">Mechanical breakdown</td><td style=";">Porrelpump motor</td><td style=";">Engineering</td><td style=";">Morning</td></tr><tr><td style="color: #161120;text-align: center;">51</td><td style=";">10:45:00</td><td style=";">10:55:00</td><td style=";">10</td><td style=";">Mechanical breakdown</td><td style=";">Repair leak on siukerbox</td><td style=";">Engineering</td><td style=";">Morning</td></tr><tr><td style="color: #161120;text-align: center;">52</td><td style=";">08:30:00</td><td style=";">10:09:00</td><td style=";">99</td><td style=";">Mechanical breakdown</td><td style=";">Rectify Jaw crusher shutte</td><td style=";">Engineering</td><td style=";">Morning</td></tr><tr><td style="color: #161120;text-align: center;">53</td><td style=";">07:00:00</td><td style=";">07:35:00</td><td style=";">35</td><td style=";">Electrical</td><td style=";">Porrel pump trip</td><td style=";">Engineering</td><td style=";">Morning</td></tr><tr><td style="color: #161120;text-align: center;">54</td><td style=";">06:00:00</td><td style=";">06:28:00</td><td style=";">28</td><td style=";">Mechanical breakdown</td><td style=";">Change pipes on puddel pump</td><td style=";">Engineering</td><td style=";">Morning</td></tr><tr><td style="color: #161120;text-align: center;">55</td><td style=";">05:10:00</td><td style=";">05:30:00</td><td style=";">20</td><td style=";">Mechanical breakdown</td><td style=";">Oversize conv stuck</td><td style=";">Metallurgical</td><td style=";">Night</td></tr><tr><td style="color: #161120;text-align: center;">56</td><td style=";">03:15:00</td><td style=";">04:00:00</td><td style=";">45</td><td style=";">Electrical</td><td style=";">Porrelpump 2 trip</td><td style=";">Engineering</td><td style=";">Night</td></tr><tr><td style="color: #161120;text-align: center;">57</td><td style=";">01:30:00</td><td style=";">02:45:00</td><td style=";">75</td><td style=";">Chokes</td><td style=";">Jaw crusher block</td><td style=";">Metallurgical</td><td style=";">Night</td></tr></tbody></table>
I have to filter data in a Pivot Table that shows it in the following order:
Morning Shift
Afternoon Shift
Night Shift
Excel 2010<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px"><colgroup><col style="background-color: #DAE7F5" width="25px"><col><col><col><col><col><col><col></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th>
</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">43</td><td style=";">Row Labels</td><td style=";">Time To</td><td style=";">Total</td><td style=";">DelayOption</td><td style=";">Delay</td><td style=";">Responsibility</td><td style=";">ShiftOption</td></tr><tr><td style="color: #161120;text-align: center;">44</td><td style=";">23:45:00</td><td style=";">00:45:00</td><td style=";">60</td><td style=";">Mechanical breakdown</td><td style=";">Oversize conv set screw broken</td><td style=";">Engineering</td><td style=";">Night</td></tr><tr><td style="color: #161120;text-align: center;">45</td><td style=";">20:00:00</td><td style=";">22:00:00</td><td style=";">120</td><td style=";">Loader unavailable</td><td style=";">Dumptruck broken undebelt oversice </td><td style=";">KUM</td><td style=";">Afternoon</td></tr><tr><td style="color: #161120;text-align: center;">46</td><td style=";">15:47:00</td><td style=";">19:00:00</td><td style=";">193</td><td style=";">Mechanical breakdown</td><td style=";">Pan 2 Trommeldrive motor bolts broken</td><td style=";">Engineering</td><td style=";">Afternoon</td></tr><tr><td style="color: #161120;text-align: center;">47</td><td style=";">15:40:00</td><td style=";">19:45:00</td><td style=";">245</td><td style=";">Electrical</td><td style=";">Pan 1 Extractor trip and block</td><td style=";">Metallurgical</td><td style=";">Afternoon</td></tr><tr><td style="color: #161120;text-align: center;">48</td><td style=";">15:00:00</td><td style=";">15:30:00</td><td style=";">30</td><td style=";">Mechanical breakdown</td><td style=";">Change porrelpump motor</td><td style=";">Engineering</td><td style=";">Afternoon</td></tr><tr><td style="color: #161120;text-align: center;">49</td><td style=";">14:00:00</td><td style=";">15:00:00</td><td style=";">60</td><td style=";">Chokes</td><td style=";">Concentrate line block</td><td style=";">Metallurgical</td><td style=";">Afternoon</td></tr><tr><td style="color: #161120;text-align: center;">50</td><td style=";">12:16:00</td><td style=";">13:00:00</td><td style=";">44</td><td style=";">Mechanical breakdown</td><td style=";">Porrelpump motor</td><td style=";">Engineering</td><td style=";">Morning</td></tr><tr><td style="color: #161120;text-align: center;">51</td><td style=";">10:45:00</td><td style=";">10:55:00</td><td style=";">10</td><td style=";">Mechanical breakdown</td><td style=";">Repair leak on siukerbox</td><td style=";">Engineering</td><td style=";">Morning</td></tr><tr><td style="color: #161120;text-align: center;">52</td><td style=";">08:30:00</td><td style=";">10:09:00</td><td style=";">99</td><td style=";">Mechanical breakdown</td><td style=";">Rectify Jaw crusher shutte</td><td style=";">Engineering</td><td style=";">Morning</td></tr><tr><td style="color: #161120;text-align: center;">53</td><td style=";">07:00:00</td><td style=";">07:35:00</td><td style=";">35</td><td style=";">Electrical</td><td style=";">Porrel pump trip</td><td style=";">Engineering</td><td style=";">Morning</td></tr><tr><td style="color: #161120;text-align: center;">54</td><td style=";">06:00:00</td><td style=";">06:28:00</td><td style=";">28</td><td style=";">Mechanical breakdown</td><td style=";">Change pipes on puddel pump</td><td style=";">Engineering</td><td style=";">Morning</td></tr><tr><td style="color: #161120;text-align: center;">55</td><td style=";">05:10:00</td><td style=";">05:30:00</td><td style=";">20</td><td style=";">Mechanical breakdown</td><td style=";">Oversize conv stuck</td><td style=";">Metallurgical</td><td style=";">Night</td></tr><tr><td style="color: #161120;text-align: center;">56</td><td style=";">03:15:00</td><td style=";">04:00:00</td><td style=";">45</td><td style=";">Electrical</td><td style=";">Porrelpump 2 trip</td><td style=";">Engineering</td><td style=";">Night</td></tr><tr><td style="color: #161120;text-align: center;">57</td><td style=";">01:30:00</td><td style=";">02:45:00</td><td style=";">75</td><td style=";">Chokes</td><td style=";">Jaw crusher block</td><td style=";">Metallurgical</td><td style=";">Night</td></tr></tbody></table>
