Generate data for a range of periods that spread into two years
SummaryGenerate data for a range of periods that spread into two years
I am working on a simple calc script but I can't seem to figure out how to make it work. My goal is to generate data for a range of periods that spread into multiple years. For example, I am trying to enter 0 for an employee starting in June FY17 and ending in Aug FY18. The data will be spread into 3 periods and 2 years. Does it make sense? Our fiscal year starts in Jul.
The cross dim functionality does not work: