Wednesday, May 25, 2011

Getting a non-measure column into the measures section in Pivot table

1. Add the non-numeric column "Status" into the rows section. This column can be a column from Dimension.
2. In the properties of "Status", click on duplicate layer. Same column will get created.
3. Drag the new column and drop it into measures section.
4. Hide the "Status" column in measure section.