Hello,
I need to create a table with sales monthly, ytd, 3 month avg, 6 month avg, 12 month avg like such:
I’ve created a calculation group to handle this so I don’t need to create 12 different measures (1 for each month).
Only issue is the request is that there is a blank column between the months and the YTD and the other columns to the right. I can create a blank column in calculation groups (=" ") but the issue is not I have a bunch of blank rows as the blank creates a record for all of the rows without sales.
Is there a way of doing this without creating 12 measures (1 for every month)?
Thanks,
Tim