Excel 2007 (and its instrument of pivoting) is a great tool for analyzing and visualizing data, especially when used in conjunction with an infrastructure based on Microsoft SQL Server / Analysis Services.
However, historically, the main shortcoming of this approach as' the impossibility to build calculated measures. For example, how can I just find the difference between two measurements if someone has already provided the difference between the available measures in the cube that I'm viewing?
PTPower is a solution (free) to solve this problem.
0 comments:
Post a Comment