Skip to Content
Former Member
Dec 07, 2014 at 11:17 AM

Bex query with YTD ,Actual and budget and Last year values in column


Hi Guys,

I need your help.

I need to have a query where in row I will have accounts . In column , I will have Actual ( in YTD ) , Budget ( in YTD ) and last year values .

So report is it will show values against each accounts ( row wise ) in Actual ( in YTD ) ,Budget ( YTD ) and Last year total Column.

Month is fixed based on selection.

I understood that I will keep accounts in row and characteristics ( category in column structure with 2 separate selection for actual and budget respectively ) in column. but I need to calculate YTD values with category = ACTUAL and category = BUDGET and for my 3rd column I need to show Last full year value. Screen shots attached.

How to accommodate that requirement .

Please guide.




Screen shot.JPG (110.7 kB)