Skip to Content
0
Nov 06, 2012 at 10:49 AM

how to show values only for the current month in cell's of bex

27 Views

Hi,

i have a requirement to show only current month data in a cell where it had some calculations over the cell,

Year Header´╗┐ 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 Header 8 Header 9
April
May June July Aug Sep Oct Nov Dec
2012 20 20 20 20 20 20 20 20 20 2011 10 10 10 10 10 10 10 10 0 Variance(2011-2012) -10 -10 -10 -10 -10 -10 -10 -10 -20









In the above table 2012-Row 1 represents current financial year and 2011-Row 2 represents Previous financial year and row

Variance(2011-2012) represents ( row 1-row 2 ) .

My requirement is to show only the values in current month for the current month variance(AS GREEN COLOURED). i don't want to show the other months values in variance(RED).

Because of the complexity in the report we have gone through with the CELL's in reporting.

Please go through with the below structure in BEX Query


somebody please help me how this can be done.

Attachments

cell.JPG (47.4 kB)