Tag: pivot table

A magical Excel trick for flattening data copied from a PivotTable report in tabular layout into usable format

Magical Trick for Data Flattening in Excel

Here is a scenario that I come across sometime ago when I received an Excel file with some apparently messy data for further processing to generate another report. The data in the file appear similar to below screenshot. This data is self-explanatory. It’s the sales in units and dollars of each product under each product... Continue Reading →

0

Calculation of metrics at database level or reporting level..? which is the best way..?

I just came across a same old situation of deciding where to do the calculation of certain metrics like percentages ? Here is my take on it with a fictitious example - Scenario 1:  Calculating it at database level and preserving it in the database: see Fig.:1(Associate Level Sales) showing a table with sales made by a few sales executives... Continue Reading →

0

Up ↑

%d bloggers like this: