Hi,
I have an issue while designing a query in query designer. i have made a query using structures in rows and columns....in rows i have restricted the characteristics with Sales Regions. In columns i have restricted the selections of sales figures by year/ month variable for cureent month and current month-1 as offset.
When i am executing the query the sales figures are appearing only in current month column .. the column in which i have set offset is appearing empty....
Following is my desired output
June 2006 July 2006
Lahore 100 200
Karachi 200 230
Islamabad 160 123
The data is not appearing in June 2006 column although the data exist in info cube for these sales regions.
Please help me in sort outing this issue.
Regards
Hina