Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Thank you