How to compare Revenue LY fiscalRevenue vs CY fiscalRevenue?

[#1]

Hi,

I want comaprision between LFY revenue vs CFY revenue in abr chart.

In bar chart My dimension is Fiscal year and my measure are two. First for current fiscal year and other for last fiscal year.

Here I am getting the same value for cy vs ly but I want 2015 revenue which is 44993c id also showing with 2016's previous year but it is showing 0 Value.

Can anyone help me out for this.

Thanks

Tanushree

[swuehl]

If your expression for CFY is something like

=Sum(Revenue)

try something like

=Above(Sum(Revenue))

for LFY revenue

See the HELP for  Above() function or more about chart inter record functions.