I've created a data model using 2 tables - tbl_calendar and tbl_Delivered_Revenue
The model is ANALYSIS.xlsx
I've created bespoke date columns based on the date range in tbl_calendar to form meaningful headers - Trading Year / Trading QTR / Trading Month as gregorian calendars dates are not the financial trading periods.
This seems to work OK and i've input a relationship between Date (ACTUAL) from tbl_calendar to Start Date from tbl_Delivered_Revenue.
I've created a simple pivot table using the data model and have Year / QTR Name / Month Name in the Rows which display fine - the issue is when i drop the Value field into [Values] it doesn't list the actual trading month revenue values, just gives me a sum total of ALL of the Value not by tradiong month.
SAMPLE_IMG.png
SAMPLE2_IMG.png
Let me know if you can see where i've gone wrong with this model.
Thanks
Bookmarks