Forum Discussion
Simple Drill Down
You clearly have hierarchies here, so you have to create them. Bear in mind that hierarchies must reside in one and the same table. When designing tables with hierarchies, think about what a Date table looks like... Once you get your hierarchy/hierarchies right, you're almost done with your task.
Here's a file that does what you want:
https://1drv.ms/u/s!ApyQEauTSLtOgZlNkcwZPyDsKLJojw?e=iWH3bv
Solution SageYou clearly have hierarchies here, so you have to create them. Bear in mind that hierarchies must reside in one and the same table. When designing tables with hierarchies, think about what a Date table looks like... Once you get your hierarchy/hierarchies right, you're almost done with your task.
Here's a file that does what you want:
https://1drv.ms/u/s!ApyQEauTSLtOgZlNkcwZPyDsKLJojw?e=iWH3bv