Display row as columns(PIVOT) with Join in Report definition
I have a requirement in pega to display join of two tables(table 1 normal, table 2 pivot the table) using report definition only.
PFA..(table data.txt) for better understanding.
I tried by using report defination but i used the aggregate function so the data is coming as summary report but i want data in tabular format so that can use in report defination in the UI.
Can any one suggest me for good approach because dynamic columns creation is happening and pega provides dynamic grid option only with report definition.