Have you ever run into the pesky problem where any text-based data (that you add as a secondary column) in a pivot table incorrectly display as values instead of text? This is because pivot tables in ...

I have exported information from an accounting package (actually 'More') to a spreadsheet where I set-up a pivot table to analyse the accounting data. The pivot table will be structured to show the ...

Tutorial: Create a P&L from transactions with a... In the tutorial Create a P&L from a monthly balances with a pivot table we imported a set of monthly balances into Excel and used a pivot table to ...

Today's addition of VB Macro and pivot table support to Zoho Sheets is possibly the most important step forward for the Zoho suite of business applications. These two capabilities are top of list for ...