3.Drag the Based on value calculated field in between the dimensions and change the compute using to Pane Down
4. Ctrl drag the Based on value calculated field from rows to filters shelf and deselect the Null value:
5. Right- click the Actual dimension for which the table calculation is calculated based upon (In this case Year[Order Date]) and deselect the Show Header option.
Please find the attached workbook for the solution.
Thank you for providing your feedback on the effectiveness of the article.