2 Replies Latest reply on Dec 18, 2013 4:42 AM by Michel Lankheet

    group data for one subcolumn

    Michel Lankheet

      Hi,

      I am facing an issue in a report where I have to group the data for one subcolumn.

      As an example, I created a superstore dataset. In this sheet, I would like to display only the total sales for East, while keeping the split per customer segment for Central.

       

      Below is a screenshot of the desired result.

      result.PNG.png

      Problably it's easy to do. I tried duplicationg the dataset, different calculations,but I can't seem to find the solution.

      Any help or tips would be appreciated.