You want to subtotal the data by year in a table but you do not have a location for the subtotal in the table. What must you do to create the location for the subtotal in the table?

What object type is found in navigation paths?

Your data source has the following values: SMITH, SMYTH, SMALL, SMOOTH, SMART, SMILEY. What syntax do you use to show only the names SMITH and SMYTH?

When using the ranking feature on a table, which expression allows you to display the total of all values (both ranked and unranked) in the footer of the block?

How do you duplicate an existing query? Note: There are 2 correct Answers to this question.