Power Pivot filter on column

A

aliceg

New Member
Joined
Nov 24, 2014
Messages
1
Hi I'm new here, I need help with how to filter on column names

I have a data table looks like this:

[TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]JAN[/TD]
[TD="width: 64"]FEB[/TD]
[TD="width: 64"]MAR[/TD]
[TD="width: 64"]APR[/TD]
[TD="width: 64"]MAY[/TD]
[TD="width: 64"]JUN[/TD]
[TD="width: 64"]JUL[/TD]
[TD="width: 64"]AUG[/TD]
[TD="width: 64"]SEP[/TD]
[TD="width: 64"]OCT[/TD]
[TD="width: 64"]NOV[/TD]
[TD="width: 64"]DEC[/TD]
[/TR]
[TR]
[TD="align: right"]800[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]800[/TD]
[/TR]
[TR]
[TD="align: right"]4400[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]4400[/TD]
[/TR]
[TR]
[TD="align: right"]12500[/TD]
[TD="align: right"]12500[/TD]
[TD="align: right"]12500[/TD]
[TD="align: right"]12500[/TD]
[TD="align: right"]12500[/TD]
[TD="align: right"]12500[/TD]
[TD="align: right"]12500[/TD]
[TD="align: right"]12500[/TD]
[TD="align: right"]12500[/TD]
[TD="align: right"]12500[/TD]
[TD="align: right"]12500[/TD]
[TD="align: right"]12500[/TD]
[/TR]
[TR]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]7500[/TD]
[TD="align: right"]17500[/TD]
[TD="align: right"]7500[/TD]
[TD="align: right"]7500[/TD]
[TD="align: right"]7500[/TD]
[TD="align: right"]7500[/TD]
[TD="align: right"]7500[/TD]
[TD="align: right"]7500[/TD]
[TD="align: right"]7200[/TD]
[TD="align: right"]6800[/TD]
[TD="align: right"]6800[/TD]
[TD="align: right"]6800[/TD]
[/TR]
[TR]
[TD="align: right"]7000[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]7000[/TD]
[/TR]
[TR]
[TD="align: right"]3000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]8042[/TD]
[TD="align: right"]8042[/TD]
[TD="align: right"]8042[/TD]
[TD="align: right"]8042[/TD]
[TD="align: right"]8042[/TD]
[TD="align: right"]8042[/TD]
[TD="align: right"]8042[/TD]
[TD="align: right"]8042[/TD]
[TD="align: right"]8042[/TD]
[TD="align: right"]8042[/TD]
[TD="align: right"]8042[/TD]
[TD="align: right"]8038[/TD]
[/TR]
[TR]
[TD="align: right"]17500[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]17500[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]17500[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]17500[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[/TR]
[TR]
[TD="align: right"]8500[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]8500[/TD]
[/TR]
[TR]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[/TR]
[TR]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1200[/TD]
[/TR]
[TR]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[/TR]
[TR]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[/TR]
[TR]
[TD="align: right"]600[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD="align: right"]38249[/TD]
[TD="align: right"]2522[/TD]
[TD="align: right"]2522[/TD]
[TD="align: right"]2522[/TD]
[TD="align: right"]2522[/TD]
[TD="align: right"]128522[/TD]
[TD="align: right"]2522[/TD]
[TD="align: right"]2522[/TD]
[TD="align: right"]2522[/TD]
[TD="align: right"]2522[/TD]
[TD="align: right"]2522[/TD]
[TD="align: right"]2522[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]17500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[/TR]
[TR]
[TD="align: right"]417[/TD]
[TD="align: right"]40416[/TD]
[TD="align: right"]417[/TD]
[TD="align: right"]417[/TD]
[TD="align: right"]417[/TD]
[TD="align: right"]417[/TD]
[TD="align: right"]417[/TD]
[TD="align: right"]417[/TD]
[TD="align: right"]417[/TD]
[TD="align: right"]417[/TD]
[TD="align: right"]417[/TD]
[TD="align: right"]417[/TD]
[/TR]
[TR]
[TD="align: right"]3333[/TD]
[TD="align: right"]3333[/TD]
[TD="align: right"]3333[/TD]
[TD="align: right"]3333[/TD]
[TD="align: right"]3333[/TD]
[TD="align: right"]3333[/TD]
[TD="align: right"]3333[/TD]
[TD="align: right"]3333[/TD]
[TD="align: right"]3333[/TD]
[TD="align: right"]3333[/TD]
[TD="align: right"]3333[/TD]
[TD="align: right"]3333[/TD]
[/TR]
[TR]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[/TR]
[TR]
[TD="align: right"]31434[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[/TR]
[TR]
[TD="align: right"]31434[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[TD="align: right"]833.5[/TD]
[/TR]
[TR]
[TD="align: right"]10800[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]


Is there any way I can add a slicer by the month to determine which column to use?
Thank you so much for your help!
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Sort by date Sort by votes
What you have here is a PERFECT use case for Power Query with it's easy "Unpivot" feature. You want 1 column w/ your data, and 1 column with "MonthName". That is what Unpivot will give you (in SQL or PowerQuery).

Leaving your data in that format will just bring sadness.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
index & match
Replies
9
Views
697
jasonb75
J
J
  • Question Question
PivotTable Percentage A-B
Replies
1
Views
740
alfranco17
A
K
  • Question Question
Converting Matrix Data to Linear Data for Pivot Table
Replies
1
Views
3K
kdinkins
K
V
  • Question Question
using VBA instead of fomula in the sheet
Replies
0
Views
540
vishal120
V

Forum statistics

Threads
1,224,050
Messages
6,176,083
Members
452,704
Latest member
Michael AA

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top