Hi,
I have a query with a structure on both my rows and columns.
In my columns, I have my key figures and on them are period/year restrictions. For example, the first column is the current fiscal period/year - 1 period, the next column is the current fiscal period/year - 13 periods (so I can compare this year to last year)
On my rows, I have a structure that is listing sales where on each line, I am restricting by groups of accounts.
What I need on my report is a header stating what the time period of the report is for. That is, the restriction of the current fiscal period/year -1 that is being placed on the first column also needs to be up in the page heading.
This is going to be hard to explain but here goes. My columns are reporting key figures constrained by time.
<page header>
REPORT: XXXXXX
REPORTING FOR: Per/Yer (Which is equal to the date restriction that is on the first KF column, that is curr yr/period - 1 period)
<report body>
SALES GROUP / RPT MONTH / LY
Mens / amount (restricted to curr year/period - 1) / amount (restricted to curr year/period - 13)
Womens / amount (-1) / amount (-13)
Childrens / amount (-1) / amount (-13)
I tired adding it to my row structure but since my KFs are constrained by per/year, I can not drop per/year onto my rows.
I tried to add a column showing time but BEx wants me to add a key figure (since the columns have key figures in them) so that does not work either.
How can I get the value of "current period/year - 1 period" to be part of the data (not a label) in the query so that I can put it into a header on my report.
Thanks for your help!