Filtering with conditions and pivot table
I have a simple table as in the link. Each loan has its own code, each loan can have multiple collaterals.
- 1st question: How can I filter with pivot table the loans that have only one type/multiple types of collateral? For example only the loan PQR/987 counts if I want to filter the loans that only have vehicle collateral and only the ABC/123 loan counts if I want to filter the loans that have multiple collaterals. I know this could be solved with adding a countifs column but I don't know how.
- 2nd question: If a loan is secured by xxx + guarantee, it will still be counted as secured by xxx alone. For example if I want to filter loans that only have property collateral, DEF/456 would still be counted along MNO/654. Is there a formula that could reflect that?
Thank you so much.
[link] [comments]
Want to read more?
Check out the full article on the original site