Page History

33. Click on the first Sum Sun Invoiced Amount field's drop down list and select Format. apply a Sum Total

Image RemovedImage Added

34. Change the Display name to Invoiced 2014. It's important to do this to provide the user with some context to help differentiate between the queries Click on the Camp Region field's drop down list and select Format. You could also select the Column Formatting menu from the main navigation bar.

35. Enable the Suppress Duplicates option. This will make the final table easier to read, with the inclusion of sub totals.

3537. While still in the Column Formatting menu, select the Sum Invoiced Amount field from the list on the left.

36. Set the name to Invoiced 2013 and close Value.

3739. Click Report > Save to activate your report.

Image RemovedImage Added

3840. Set the Name of your report to Append Union Sub Query Tutorial.

3941. Set the Description to This report was written using the Sub Query Tutorial.

4042. Select Tutorial as the Category.

4143. Select Training as the Sub Category.

4244. Click Activate to finish.

Image RemovedImage Added

4345. You now have an active Append Union Sub Query report.

Image RemovedImage Added