This would be more helpful if you can share a sample workbook to understand better and replicate the same.
Attaching a sample worksheet with sample data.
In the test sheet filtered the Category for fixed and view by as SKU.Sku is the lowest level of data
However when I change the view by parameter to PF/PL etc it is not summing to 0.2.I need that to be summed up.Basically sum of the aggregation when looked at group by
Can somebody please help me on this.Any help would be really gratefull.
test.twbx 218.1 KB