I have 138 Columns with 365 days are rows. Each day any of 138 columns may have some numeric value, I want to create a view so that I can filter or search sales done on specific item (column value) for the year etc. You need to connect to my desktop for accessing the database.
New View should have 3 columns like Date Value Sale Amount
Value Column will have the values of all original column names found in the table.
Example say if original column is like this:
Date program1 program 2
4/4/2018 200 200
I want new View to be like this
Date Value Sale_amount
So that I should be able to generate report like show me all sales generated from Program1 etc