I have a table for Profit and Analysis Report with 7 levels of hierarchies which is displayed in Pivot table. In Pivot table, drill down is shown from level 1 to level 7. But the requirement is to customize the hierarchy. (ie) To show some element in Hierarchy 1, Hierarchy 2 and Hierarchy 4 at first level. Please help me to know if there are any extensions available for this. Attaching the screenshot of the existing layout,
Is it possible to have visualization that caters the need where to show EBITDA, Delivered Margin, Amortization at a single level,
Thanks a lot,
Solved! Go to Solution.
Have gone through the extension. It would be more helpful if you could please let me know if there are any extensions where there is possibility of including Dimensions as 'Rows' rather than 'Columns'.
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.
Hi, I don't have an answer to date. I suggest you put a request on the branch project and ask the developer of the extension.