Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
The simplest solution I can think of is to generate a separate calendar and then map you transaction dates to it.
Since it is a data set that doesn't change - You can create the calendar in Excel
Hmm, there are a few ways you could do this.
The simplest that I use is to create a year and period list box (if you set the year box to only allow a single selection it works best)
Then use a set analysis modifier along these lines...
Sum({<Year={$(=(Num(GetFieldSelections(Year)))-1)}>} Revenue)
This will take the current selections and filter them by a different year.
E.g.
The simplest solution I can think of is to generate a separate calendar and then map you transaction dates to it.
Since it is a data set that doesn't change - You can create the calendar in Excel
Hmm, there are a few ways you could do this.
The simplest that I use is to create a year and period list box (if you set the year box to only allow a single selection it works best)
Then use a set analysis modifier along these lines...
Sum({<Year={$(=(Num(GetFieldSelections(Year)))-1)}>} Revenue)
This will take the current selections and filter them by a different year.
E.g.
.png "Former Employee"){kind=icon}
