Skip to Content
0
Former Member
Sep 17, 2007 at 03:54 AM

Problem in column having offset variable.

30 Views

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