One Filter made up of record from three columns

[BB0725]

Hello Everyone, 

I have an account table with three columns Account, PreInc, and EBIT. The account column is made up of Revenue, Compensation, and Incentive. The PreInc column is made up of PreInc and Incentive, then lastly the EBIT column is just EBIT .

Is there a way I can make a horizontal filter that will show Revenue, Compensation, PreInc, and EBIT?

Example of the table below.

Account	PreInc	EBIT
Revenue	PreInc	EBIT
Compensation	PreInc	EBIT
Incentive	Incentive	EBIT