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 9In 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.