Filtering out date hierarchy in Matrix

Hi Piotr,

Thank you for the forum question.

I am not sure that I understand the question.

If you create a matrix and add the dates from you Date table (or the Quarter column and Month column from you date table) in the Columns field box of the matrix and you expand the matrix (click on the connected double down arrow right side of the matrix) the matrix will display the values for quarters and months in separate columns.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector