Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
help needed for a set analysis expression for calculating the percentage of for Column 'a' like ( Sum(a)/Count(a) *100) shown in the chart for previous year and current year.
maybe for prev year
sum( {$<Year = {$(=Max(Year)-1)}>} a ) / count( {$<Year = {$(=Max(Year)-1)}>} a )
Ranjit,
You should try to use Year as dimension of the chart.
Hope it helps!
Regards
Jonathan-
maybe for prev year
sum( {$<Year = {$(=Max(Year)-1)}>} a ) / count( {$<Year = {$(=Max(Year)-1)}>} a )
thanks Jonathan for the quick reply.
It worked thanks buddy..
You might find this helpful: