Lotus User
New Member
- Joined
- Jan 3, 2018
- Messages
- 17
I have a fairly simple table that I have created a pivot table for. I can't seem to figure out how to filter the pivot table to only show certain data (excluding sub totals and totals). Here is a screen shot of the info(I have removed subtotals and totals): I need to filter the data to show anyone that has greater than 24hours in one day. When I create a filter on hours, it doesn't filter on the sum, it filters on the source so my largest option is 15 hours. Ultimately my goal is to sort pivot table hours and only show >24...which would be Jane....
[TABLE="width: 351"]
<colgroup><col width="64" style="width: 48pt;" span="4"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;"> <col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" span="2"> <tbody>[TR]
[TD="width: 64, bgcolor: #EEECE1"]Name[/TD]
[TD="width: 64, bgcolor: #EEECE1"]Date[/TD]
[TD="width: 64, bgcolor: #EEECE1"]Hours[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 89, bgcolor: transparent"][/TD]
[TD="width: 61, bgcolor: transparent"][/TD]
[TD="width: 61, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jane[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]John[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]8[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Hours[/TD]
[TD="bgcolor: transparent"](All)[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Joe[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Mary[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Sum of Hours[/TD]
[TD="bgcolor: transparent"]Date[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Mike[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]9[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Name[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]7/2/2019
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jane[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Jane[/TD]
[TD="bgcolor: transparent, align: right"]30[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]John[/TD]
[TD="bgcolor: transparent, align: right"]7/2/2019[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Joe[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Joe[/TD]
[TD="bgcolor: transparent, align: right"]7/2/2019[/TD]
[TD="bgcolor: transparent, align: right"]8[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]John[/TD]
[TD="bgcolor: transparent, align: right"]8[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Mary[/TD]
[TD="bgcolor: transparent, align: right"]7/2/2019[/TD]
[TD="bgcolor: transparent, align: right"]7[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Mary[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent, align: right"]7[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Mike[/TD]
[TD="bgcolor: transparent, align: right"]7/2/2019[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Mike[/TD]
[TD="bgcolor: transparent, align: right"]9[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 351"]
<colgroup><col width="64" style="width: 48pt;" span="4"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;"> <col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" span="2"> <tbody>[TR]
[TD="width: 64, bgcolor: #EEECE1"]Name[/TD]
[TD="width: 64, bgcolor: #EEECE1"]Date[/TD]
[TD="width: 64, bgcolor: #EEECE1"]Hours[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 89, bgcolor: transparent"][/TD]
[TD="width: 61, bgcolor: transparent"][/TD]
[TD="width: 61, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jane[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]John[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]8[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Hours[/TD]
[TD="bgcolor: transparent"](All)[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Joe[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Mary[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Sum of Hours[/TD]
[TD="bgcolor: transparent"]Date[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Mike[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]9[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Name[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]7/2/2019
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jane[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Jane[/TD]
[TD="bgcolor: transparent, align: right"]30[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]John[/TD]
[TD="bgcolor: transparent, align: right"]7/2/2019[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Joe[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Joe[/TD]
[TD="bgcolor: transparent, align: right"]7/2/2019[/TD]
[TD="bgcolor: transparent, align: right"]8[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]John[/TD]
[TD="bgcolor: transparent, align: right"]8[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Mary[/TD]
[TD="bgcolor: transparent, align: right"]7/2/2019[/TD]
[TD="bgcolor: transparent, align: right"]7[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Mary[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent, align: right"]7[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Mike[/TD]
[TD="bgcolor: transparent, align: right"]7/2/2019[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Mike[/TD]
[TD="bgcolor: transparent, align: right"]9[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]