Ok, here is an excellent solution. – open the pivot table – put a measure – double click a number in the PivotTable – you get a new worksheet with the details of the measure you double-clicked – right-click any cell of the table you see and click “Edit Query…” – replace the query content Read More