Skip to Content
0
Dec 09, 2011 at 09:46 AM

Re: additional column problem

39 Views

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