Renaming Totals (Summaries) From A Single Query

[t0mato]

Hi,

Imagine this report:

Column A: Lists Countries (e.g. USA, CAN, etc.)
Column B: Lists States (e.g. Illinois, Arkansas, California, and other country's states)
Column C: Lists Cities (e.g. Chicago, Houston, and other countries cities)

I've grouped columns A, B, and C separately. I have a query that totals the number of entries for each column.

My total, when added to the report page, the naming is simply duplicated when exported.

For example for the Column A Group, the total appears as Total Entries
For Column B group, the total appears as Total Entries (2)
For Column C group, the total appears as Total Entries (3)

Each of these Total Entries are corresponding to their group (as they should) but is there a way to rename them so it's not just (2) and (3)? Could I perhaps rename them to 'Total Entries by Country', 'Total Entries by State',  'Total Entries by City'?

Is this possible? Will I need to make separate queries named as such for each one of these?

Thanks!

[MFGF]

Hi,

Imagine this report:

Column A: Lists Countries (e.g. USA, CAN, etc.)
Column B: Lists States (e.g. Illinois, Arkansas, California, and other country's states)
Column C: Lists Cities (e.g. Chicago, Houston, and other countries cities)

I've grouped columns A, B, and C separately. I have a query that totals the number of entries for each column.

My total, when added to the report page, the naming is simply duplicated when exported.

For example for the Column A Group, the total appears as Total Entries
For Column B group, the total appears as Total Entries (2)
For Column C group, the total appears as Total Entries (3)

Each of these Total Entries are corresponding to their group (as they should) but is there a way to rename them so it's not just (2) and (3)? Could I perhaps rename them to 'Total Entries by Country', 'Total Entries by State',  'Total Entries by City'?

Is this possible? Will I need to make separate queries named as such for each one of these?

Thanks!

Hi,

Any item you define has both a name and a label. If you select the item on the report page, and open the Properties pane, you should see both. What are they currently set to?

MF.