3 Replies Latest reply: Nov 10, 2011 10:17 AM by Nicolas DUPONT RSS

    Pivot table with custom lines

      Hi,

       

      I'd like to design a financial analysis table based on account categories (pretty classic). The difficulty is that i also want to insert custom lines with intermediate calculations at specific places.

       

      Here is an example :

       

      PivotCustom.PNG

       

      I don't think it's possible with a pivot table because it breaks the dimensions; so i have the following questions :

      1. Am i right ?

      2. Do you know if a custom control which could fit the need exists ?

      3. Can you think about a workaround ? Mine would be to build 2 tables : a pivot table & a straight table containing the indicators corresponding to the custom lines i want to insert, based on expressions & set analysis to recalculate the agregation made in pivot table.

       

      Thanks.