3 ms·
Excel has pivot table feature but not sure if it works with SQL database. For analysts or business users you need just drag and drop feature but it is always g
by njx 10y ago
Excel has pivot table feature but not sure if it works with SQL database.
For analysts or business users you need just drag and drop feature but it is always good to know what SQL is generated by the actions like you can see that with
http://infocaptor.com/ http://infocaptor.com/
http://infocaptor.com/img_assets/finance_data_viz1.gif http://infocaptor.com/img_assets/finance_data_viz1.gif
- cm2187 10y agoIt works with an excel database but it requires you to select a single table through a join, downloads all data to memory, and then does the pivotting in-memory. Impractical for a large dataset.