Hi
I speek only a little english, so I try to explain my problem.
I have daily NAV in a fund application.
My pivot's dimensions are FUND_ID and MonthName(NAV_DATA), I want to calculate an customized average :
NAV(lastdayinmonth)-NAV(firstdayinmonth)/365
I used set analysis
(SUM({<NAV_DATA={'$(=date(MAX(NAV_DATA)))'}>} NAV)-SUM({<NAV_DATA={'$(=date(MIN(NAV_DATA)))'}>} NAV))/365, however MAX and MIN are calulated on ALL CURRENT SELECTION DATES, but I whish they were calculated on all DATES included in CURRENT DIMENSION value (pivot's row) .
can anyone help me?
Thanks