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