3 of 3 people found this helpful
I think what you're talking about here is a hierarchy drilldown -- similar to what you would see when you add a date field to columns or rows; start with Year and then drill into Quarter and then to Months etc.
You can create custom hierarchies by dragging one dimension ontop of another in the data window (the list of dimensions and measures on the left of the screen). Alternatively, you can select multiple dimensions with the mouse and Ctrl key and the right click and select Create Hierarchy. Now when you add the top level dimension in the hierarchy, you can drill down into the lower level(s) by using the + button on the view.
In your example, it Region happens to already be the highest level of dimensions and you simply want to see a grand total, try creating a new calculated field, e.g. 'Country' with the formula 'Italy', and add that as your highest level in the hierarchy.
Hope that helps
is there a sample workbook i could refer to to see how the collapse hierarchies are created?