Hi Guru's,
Using: SAP BO ENTERPRISE XI Product: 12.1.0
I have created a variable to get the Months_ Age of calender date
=(Year(CurrentDate())*12 + MonthNumberOfYear(CurrentDate())) - (Year([Calendar Date])*12 + MonthNumberOfYear([Calendar Date]))
My requirement is to get the previous 12 months data in a cross tab
for ex:
>>>>>>>>>>>>>>01>>>>02>>>......>>>12{Monts_Age<12}
Division01>>>>100>>>200...>>>>>500
Division02>>>>190>>>290...>>>>>50
for this I created above variable Month_age
and I created one more variable to get only last 12 months
=[Months_Age]Where([Months_Age]<12)
But the problem is I'm Getting an Extra column at the End which is Empty as heading and underneath it showing the values sum(all other values which is not less than 12 months)
>>>>>>>>>>> 01>>>>02>>>......>>>12>>>>>Blank>>{Monts_Age<12}
Division01>>>>100>>>200...>>>>>500>>>>>40000
Division02>>>>190>>>290...>>>>>50>>>>>>50000
I need to get rid of this empty heading values column.
Or Please tell me is there any other possibility, I don't have universe or custom SQL access authorization, i have to do in WEBINTELLIGENCE only
Regards,
Ranganath
Edited by: Ranganath on Dec 9, 2011 11:18 AM