There are three available tools for aggregation and transformation in Dataset Viewer depending on the issue and dataset type:
Time transformation and aggregation for regular datasets
What is the on-the-fly aggregation?
'On-the-fly' aggregation feature is a simple calculation functionality available directly into the dataset viewer inside the particular dimension - measure. Fly...