I would use calculated columns in the raw data, then use that to filter or slice on.