When I'm moving workbooks from one data source to another data source, while tedious because certain calcs and pills don't carry over, I usually open both workbooks and simply right-click to copy the calculated field from the old workbook/view (in your case a grouping) and then paste into the new workbook. Not sure if that will work for you or not? Worth a try. Thx, Don
that's exactly what is needed.
copy over all the calc fields in one shot (press down ctrl key)
and paste them to the new data source.