4 Replies Latest reply: Dec 5, 2016 4:23 AM by David Ganly RSS

    Is there a way to customize rows in Pivot Table ?

    Raja Indian Prakaash

      Hi Guys,

       

      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,

       

      PNL.png

      Is it possible to have visualization that caters the need where to show EBITDA, Delivered Margin, Amortization at a single level,

       

      Thanks a lot,

      Selva