9 Replies Latest reply: Feb 26, 2018 1:18 PM by Jorn Vangoidtsenhoven RSS

    Set analysis in a pivot table

    Jorn Vangoidtsenhoven

      I have the following pivot table: see attached.

       

      Rows = Month, measures

      Columns = Marketing type

      Measures = multiple, including "% of Loans"

       

      % of Loans is calculated as:  that month's "Loans Generated" divided by that columns sum of "Loans Generated" across all the months.

       

      I'm trying different versions of set analysis and total, but haven't been able to get the working formula yet.  Can someone help? Thanks!