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

    Grouping parts of dimensions as other in pivot tables


      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