8 Replies Latest reply on Nov 14, 2017 9:57 AM by perry.stupp Branched to a new discussion.

    How to partition by a dimension that is not displayed


      I'm trying to categorize customers by sales per year as in the following table;


      I have a calculated field for the Category which works great when I partition the data explicitly by Customer Name.  But I'd like to aggregate this information by its category without having to represent individual customers in the report (ie where customer is not displayed).


      I'd like to be able to produce the following results (partitioned by customer and then summed by Category).



      The closest I've come is as follows;

      but there's still one entry (shape) per customer and I'm not able to aggregate the values as needed.


      Any help is greatly appreciated.