Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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, previous week count previous year and so on. But,the problem here it is ,it showing only measure names instead of date values in matrix column headers. 

 

I wanted replace measure names with dates. I hope its clear? How to dynamically display the column headers in Matrix report.

 

Currently the data appearing as below:

 

Business Unit Previous Year  Current YearPrevious Year MonthCurrent Year MonthPrevious Year weekCurrent Year week
112152211
212153422
313141513

 

Excepeted report should be like below

 

Business Unit  2019 (total YTD till system date previous year)  2020 ( total YTD till system date)June 2019(total MTD till system date previous year)June 2020 (total MTD till system date current year)06/10/2019(WK)06/10/2019(WK)
112152211
212153422
313141513

2 Replies