How do I create the column set to have a column for each month and a total for the year? I want to be able to select the year and then have the columns for each month.
Solved
Trending financial report
Best answer by Laura02
Hi,
Notice the Visible Formula. you will edit the numbers in the formula for each month:
Month 4: =iif((@EndPeriod>='04' and @StartPeriod<='05'),True,False)
Month 5: =iif((@EndPeriod>='05' and @StartPeriod<='06'),True,False)
and so on.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.