ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What we...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 ...hosting database... ActivityLog...contains activity, staffID, resourceID, start time, end time... Report Specification PivotTable Report...resources in row (along the side)......staff in columns (along the top)......persondays in values (the...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB