11 Replies Latest reply: Dec 11, 2014 7:01 PM by Kiruthigadevi Subramaniam RSS

    Regarding number of columns in a pivot table

    Kiruthigadevi Subramaniam

      Hello Friends,

      I appreciate your time.

       

      I have a pivot table with dimesions contractid, contractname,planid , utility type,formid and expresion is

      sum(sales)/trans#

       

      where trans# is :No of lines coming up for that specific combination of contract, plan, utilization type, form Id

       

      So how to get that line number in a pivot table?

       

      Kindly let me know.

      Kind regards,

      Kiru