We are using BPC 5.1 SP06. I have created a report using one of the templates and the spec is as follows:
Rows: AccountL - expands DPS
Columns: Time - SELF - I have manually added an additional column next to my member in the Control Panel across the top with the EVTIM() function that returns the same period in the previous year.
I then copied the EVGTS column in my data table and pasted an additional one next to it to return the values for th EVTIM() column. This works perfectly for a static report, however when I change my account selection and th number of rows decreases or increases my first column expands and decreases along with it but the EVTIM() results column seems static and does not dynamically expand.
How should I go about including the EVTIME() column in the dynamic expanding of rows?