Set Analysis Expresion Question

[zwyne]

Hi Experts,

I have a question to ask you.

I’m trying to get percentages on a table so the issue I have is that the calculation must be for a period of 6 months. I have created the variable as vPrevMonth=date(Monthend(date(addmonths(max(APP_MONTH),-5), 'MMM-YY')), 'MMM-YY')  to get the 6 months period but I can’t get it right on the pivot table. The pivot is the calculation done for 1 month, I need the same calculation for a 6 month period.

PFA,

Regards

[Anonymous · Accepted solution]

try this Expression (Need to check the origin values to see if percentage is correct)

=sum({<APP_MONTH={'>=$(=vPrevMonth7)<=$(=max(APP_MONTH))'}>}Count)/sum(total<BA10> {<APP_MONTH={'>=$(=vPrevMonth7)<=$(=max(APP_MONTH))'}>} Count)

[zwyne]

Thank you