This cell is an aggregation. Only underlying data can be edited

Hi Chris,

It’s a common error you may see while editing data. It means that the view is actually an aggregation (yes, like in the message) so you either have one or several selectors set on several items, or you’re missing a dimension in your view.
Let’s say you’re trying to change a metric that’s Sales by Product x Country. You can see in my screenshot that Product Category is set to All values. This means that if you were to input a value, Pigment wouldn’t know on which Product Category to input the number.

Here I’ve selected the Product Category : Shirts which is the finest level of data on my metric. The cell appears light yellow when I hover my mouse, which means the data can be edited.

If you’d want to make sure you don’t forget about this, you can change the page options and set the selector as a single selector (no aggregation possible).

What if you don’t have any selectors left? Sometimes you may have removed some dimensions from the view itself, so you’ll have to add it again as rows, columns or pages. Make sure all dimensions are present in your view, select the finest level and you should be good to go!