K Karthik New Member Dec 6, 2011 #1 Hi, How can we add the same data field as both a report filter and as a row label in a pivot table. I remember doing this earlier, but for some weird reason, I'm not able to do it now. Any help? (FYI, I'm using Excel 2010 on Windows) Best, Karthik
Hi, How can we add the same data field as both a report filter and as a row label in a pivot table. I remember doing this earlier, but for some weird reason, I'm not able to do it now. Any help? (FYI, I'm using Excel 2010 on Windows) Best, Karthik
P prasaddn Active Member Feb 21, 2012 #2 Hi, I found one solution is by duplicating the column with same values and using the duplicated column. refer: http://answers.microsoft.com/en-us/office/forum/office_2007-excel/pivot-table-field-as-a-report-filter-and-a-row-or/1a7da45b-9569-4168-8114-58b0c89cbb3f Any other solutions? Regards, Prasad DN
Hi, I found one solution is by duplicating the column with same values and using the duplicated column. refer: http://answers.microsoft.com/en-us/office/forum/office_2007-excel/pivot-table-field-as-a-report-filter-and-a-row-or/1a7da45b-9569-4168-8114-58b0c89cbb3f Any other solutions? Regards, Prasad DN
S Sachin New Member Feb 21, 2012 #3 I echo Prasad's suggestion. It's the only way to make it work now. I think in 2003 you could reuse fields as row, column or page, but now you can't.
I echo Prasad's suggestion. It's the only way to make it work now. I think in 2003 you could reuse fields as row, column or page, but now you can't.
