Display last value in range instead of total

[#1]

Hi All,

I have a pivot table that represents number of donors by segment and month (see the attachment).

On this pivot table for Active donors in total I want to display the last Month Value instead of total.

Is it possible?  Please Help.

Thanks

[settu_periasamy]

Hi Denis,

Like this?

I created one variable for Max MonthYear (This will related to your Fiscal Year1)

variable name: vMaxMonthYear

=Date(Max({<FiscalYear = {'$(=maxstring(FiscalYear1))'}>}Date#(MonthYear,'MMM-YYYY')),'MMM-YYYY')

and, the Last Year expression is like

=if(Dimensionality()=0,
count({<FiscalYear = {'$(=maxstring(FiscalYear1))'},[Gift Type] = {[Recurring Gift Pay-Cash]},
MonthYear={'$(=vMaxMonthYear)'},DonorCurentSegment = {'Active'}>} distinct [Constituent ID]),
count({<FiscalYear = {'$(=maxstring(FiscalYear1))'},[Gift Type] = {[Recurring Gift Pay-Cash]}, DonorCurentSegment = {'Active'}>} distinct [Constituent ID]))

[#3]

Hi Settu,

Thanks it does work.

The only thing that it would work for a last year only.

For current year it does not work as I do not have data for a last Month of the current year.

In current year total it should display the data of a last Month that has data on it.

Is is possible?

Thanks