martinpaiva
New Member
Hi All,
I work in a small company and we have an excel file to track some changes, after each change we recieved like a receipt but some times this happen days after the change.
I have a workbook with all the transactions and one more column "Receipt?" ... In this column are 3 options "Yes", "No" and nothing. Then I create a pivot table to track all the transactions that already didn't have a "Receipt".
My problem is when if i all the values on these column as "Yes"; I lost the filter on the pivot table...
There is a way to have a fixed filter on a pivot table? Like:
>In a pivot table show all the records that have "No" in the "Receipt?" column. If there are no rows with these value, not show nothing.
Hope you can help me!
Thank you so much!
Martin Paiva
I work in a small company and we have an excel file to track some changes, after each change we recieved like a receipt but some times this happen days after the change.
I have a workbook with all the transactions and one more column "Receipt?" ... In this column are 3 options "Yes", "No" and nothing. Then I create a pivot table to track all the transactions that already didn't have a "Receipt".
My problem is when if i all the values on these column as "Yes"; I lost the filter on the pivot table...
There is a way to have a fixed filter on a pivot table? Like:
>In a pivot table show all the records that have "No" in the "Receipt?" column. If there are no rows with these value, not show nothing.
Hope you can help me!
Thank you so much!
Martin Paiva
