Forum Discussion
hamadani
4 years agoFrequent Visitor
Conditional Count of Multi Columns with Filters
Hello,
I have a table with the following 5 columns:
| Customer ID | Loan 1 | Loan 2 | Loan 3 | Loan 4 |
| Cust1 | A | D | ||
| Cust2 | B | A | C | D |
| Cust3 | D | |||
| Cust4 | B | A | D |
I have a slicer filter for the Loan where I can choose from the exisiting loans (A, B, C, D)
What I want to do is to show the total number of customers who have taken a particular loan (based on the slicer selection filter). For instance, if the user chooses Loan A from the filter, the card shows 3 or if the user chooses C, the card shows 1
Any help would be appreciated
hamadani , Unpivot the 4 columns Loan1 -4 and then try to use the filter
1 Reply
- amitchandak
Super User
hamadani , Unpivot the 4 columns Loan1 -4 and then try to use the filter