Home

Pivot tables formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1195069%22%20slang%3D%22en-US%22%3EPivot%20tables%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1195069%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20littil%20qustion%20about%20the%20Pivot%20tables%2C%3C%2FP%3E%3CP%3EI%20need%20to%20be%20able%20to%20choose%20diffirant%20Cell%20formula%20instead%20of%20numbers%20only%2C%20I%20need%20Text%20formula.%20beacous%20I%20have%20a%20big%20data%20and%20I%20need%20to%20arrange%20this%20data%20to%20be%20clear%20and%20easy%20to%20read.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20idea%20of%20pivot%20tables%20are%20fantastic%20but%20it%20taking%20only%20numbers!%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1195069%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1195342%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1195342%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F567584%22%20target%3D%22_blank%22%3E%40ahlamalbadah%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20elaborate%20your%20query%20again%20by%20attaching%20sample%20workbook%20with%20your%20desired%20result%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%20Faraz%20Shaikh%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello everyone,

 

I have littil qustion about the Pivot tables,

I need to be able to choose diffirant Cell formula instead of numbers only, I need Text formula. beacous I have a big data and I need to arrange this data to be clear and easy to read.

 

The idea of pivot tables are fantastic but it taking only numbers!

1 Reply
Highlighted

Hi @ahlamalbadah ,

 

Could you elaborate your query again by attaching sample workbook with your desired result ?

 

Regards, Faraz Shaikh 

Related Conversations
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
Filter complex table to simple table
Sam2009 in Excel on
1 Replies
Excel Table Size in Macro
WayneEK in Excel on
6 Replies