Dynamic Columns

I have a view which has multiple measures calcuated at database level like current year count ,previous year count, current year month count, previous year same period count ,current year week count,...