lundi 30 mars 2015

Combine pivot tables with different but compatible measures?

I have a pivot table that displays agencies in rows, products in columns and sales units as values. I have to make up a report in this format:


Desired pivot layout


Data is coming from an SQL Server Analysis Services and the "Estimate 2015" measure is a different measure (but uses the same dimensions and granularity so it is in fact possible to display the values side by side).


I could add a separate pivot table for the estimates, but then filtering or sorting the two tables will make them loose sync.


Is it possible to somehow align or combine pivot tables with different measures nicely?


Aucun commentaire:

Enregistrer un commentaire