Help regarding making a Pivot table.

[GravityDead]

Hey guys.

I never used pivot before and so, after playing with it for an hour or two, I am finally here to ask for assistance as I couldn't Google myself much because my broadband is not working for last 2 days and searching on mobile is difficult while working.

Pardon me for the long post.

///Query begins

I have a table with 16 columns:
"InvoiceNumber",
"Date",
7 columns for 7 codes, ("Code-1", "Code-2" till "Code-7")
"Total",
5 columns for 5 different Banks ("Bank-1", "Bank-2" till "Bank-5")
and one for "Cash".

It is a table for recording Invoices obviously and when I enter Code(s) in various "Codes" columns (on an average 2 codes are entered per invoice), the "Total" column gets filled, pulling their respective prices from another sheet and adding them.

So now I need a pivot table (or something similar) where I can get the date, invoice number, bank and cash details for each transaction in which a specific code (say filter) is present in any of the 7 columns for codes.

Query ends///

I was able to get the date (and invoice number as expandable option under date) under "rows" area of pivot table and 6 columns for banks & cash info under "Values" area of pivot table as sum of each bank and cash.
But I couldn't find out that how can I apply a filter that searches through all the 7 codes columns instead of just one.

I really hope you guys can find some sense in this question as I'm not really good at explaining things. :'(

Hoping to find a solution sooner rather than later, though at this point I really wish I knew MS-Access. A database would have been much better for my purpose. One day may be

 

[GravityDead]

Here are two screenshots of it helps.