Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table value filter
I'm comparing quarterly volume in a pivot table (I brought in the values and
am showing them as "difference from" the prior quarter). I have many rows with no Q/Q change and would like to filter them out, but when I filter the rows selecting a value filter with "difference" <0, I still see the rows with zero change. any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table value filter
Hi David. The problem is the format. the 0 is not in the right format
(number). The best way I know to do this is converting to number with the formula =value(), then you can apply the filte "does not equal" to 0 and it should work. -- Alex *Remember to click "yes" if this post helped you. Thank you! "David" wrote: I'm comparing quarterly volume in a pivot table (I brought in the values and am showing them as "difference from" the prior quarter). I have many rows with no Q/Q change and would like to filter them out, but when I filter the rows selecting a value filter with "difference" <0, I still see the rows with zero change. any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table filter | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
filter on pivot table | Excel Discussion (Misc queries) |