Hi,
I do have what I want but is there a better way of doing this?
I want to calculate the average sales for each year based on the sum of monthly totals,
I've first tried;
Which give the total per year and then divides by 12, after a few more attempts I used crossjoin with ALL and VALUES;![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
so if anyone knows a better way please let me know.
Richard.
Bookmarks