7 Replies Latest reply: Jun 7, 2012 2:59 AM by Jason Michaelides RSS

    Grouping parts of dimensions as other in pivot tables

      Hi,

      I have a problem with grouping a customer dimension in a other post in my sales forecast pivot tables. I always want to keep the same 9 customers + an other post with the rest customers in my pivots.

       

      In stacked bar charts I can do this by limiting the customer in the presentation tab. The same with pie charts where I both can limit the number of slices or set a percentage as gate.

       

      How can I do this in the best way for pivot tables?

       

      Thanks for your help