<p>I am doing a crosstab report attach is the excel data and format i am looking. I have managed to add the columns as the month-year and rows as category and promotion but what i am looking is to show category and promotion in same column with slight indentation see image.</p>
<p> </p>
<p>I am also struggling in shortening the month name and showing a merged cell for 'monthly actual' as in the image. How do i add additional column like the Target that only varies across catagory</p>
<p> </p>
<p>How do i add a calculated column to show MoM, I know there is a grand total option but it does not have difference option. I want MoM to be difference of the last two month. and do a conditional formatting to indicate RAG.</p>
<p> </p>
<p>How do i show last three months for the selected month ? Is there any easy solution ? </p>
<p> </p>
<p>Any sort of help will be great as i am new to BIRT</p>
<div> </div>
