Thank you. With some modifications in SQL, we can able to show the PNL report in the expected format. Just a small clarification. In that extension, if we use 'monthname' formula to display the months, its showing January as 'ENE', April as "Abr'. Is there a way to show English calendar the same way. Any specific formula to use to achieve the same. Kindly assist.
Also i have tried creating drill down dimension with Account Group and Account code. But it isn't working in the extension. Can you please help on this aspect as well.