Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create a filter by column name

Hello everyone, i was wondering if its possible to create a filter according to column name, let me explain, 

 

I have this table with the columns

 

Lender, business_name, closers, opener, gross margin

 

I want the filter to be between lenders,business_name, closers and opener

So imagine i have this 

 

 

Lender           Business Name             Opener                  Closer                  Gross Margin
Lender ABusiness AOpener ACloser A976
Lender ABusiness BOpener ACloser A454
Lender ABusiness COpener BCloser A517
Lender BBusiness DOpener CCloser A813
Lender BBusiness EOpener CCloser B810
Lender CBusiness FOpener DCloser B783
Lender DBusiness GOpener ECloser C394

 

 

now i want to filter the page by column,

if i press Lender, i want this result, it will remove or filter out all other columns and sum up the gross margin according to Lender and same as business name, opener, closer

Lender                   Gross Margin
Lender A1947
Lender B1623
Lender C783
Lender D394


and if i press business i get this result and so on ,

Business Name             Gross Margin
Business A976
Business B454
Business C517
Business D813
Business E810
Business F783
Business G394


is it possible?

1 Reply