2 Replies Latest reply on Sep 7, 2016 2:02 AM by Enrico Stancanelli

    How to aggregate dimensions

    Enrico Stancanelli

      Hi everybody

       

      i have a little and stupid problem that I can't resolve:

       

      in the attached file you can see a pivot and a graph.

       

      -Pivot show only "Public Value" (I want see data only if count of "Product Group"+"Country" is at least 3)

       

      -graph should show "Blind Value" and how you can see there is a row for each country.

       

      My problem is that i need to aggregate data on graph: i do not want to see every country, i have to see only one row for "Product Grouped". I can't remove "Country" from worksheet or "B/P PG_Country" doesn't work. I would like to have a total for each "Product Grouped" without "Country" subdivision.

       

      It is possibile ???

       

      Thanks in advance

       

      Enrico