1.

How to use groups in a calculated field?

Answer»

Add the ‘GroupBy’ clause to SQL queries or create a calculated field in the data window to GROUP fields.

  • Using groups in a calculation. You cannot REFERENCE ad-hoc groups in a calculation.
  • Blend data using groups created in the secondary data source: Only calculated groups can be USED in data blending if the group was created in the secondary data source.
  • Use a group in another workbook. You can easily REPLICATE a group in another workbook by copy and pasting a calculation.


Discussion

No Comment Found

Related InterviewSolutions