Hi

I cracked it finally, when I used below formula to fetch quarter wise details.

Dual(Year([EncDate])&'-Q'&Num(Ceil(Num(Month([EncDate]))/3)),QuarterStart([EncDate]))

For percentage, I have used below formula -

Sum(Gross)/Sum(TOTAL <[EncDate.autoCalendar.YearQuarter]> Gross)

Also I have loaded only specific AcCodes while loading data instead of all AcCodes so as to avoid NULL values.

Hope this is helpful to all.

Thanks and Regards,

Abhijit ARANKALLE.