PIVOT TABLE

%3CLINGO-SUB%20id%3D%22lingo-sub-1369975%22%20slang%3D%22en-US%22%3EPIVOT%20TABLE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1369975%22%20slang%3D%22en-US%22%3E%3CP%3Ewant%20to%20apply%20filter%20to%20pivot%20table%20by%20adding%20one%20more%20column%20or%20available%20column%20itself%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1369975%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1385643%22%20slang%3D%22en-US%22%3ERe%3A%20PIVOT%20TABLE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385643%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F659670%22%20target%3D%22_blank%22%3E%40narayanapathulothu%3C%2FA%3E%26nbsp%3BJust%20add%20the%20colomn%20in%20the%20dataset%20and%20refresh%20the%20Pivot%20Table%20to%20get%20the%20column%20required%20for%20filter%20the%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

want to apply filter to pivot table by adding one more column or available column itself

 

1 Reply
Highlighted

@narayanapathulothu Just add the colomn in the dataset and refresh the Pivot Table to get the column required for filter the data.