Summary report column limitation
I'm creating a Summary report and I'm trying to create a 7th row under the Grouping and crosstab section, but the green "+" button is unavailable to click. Is this is a limitation of the Summary repo...
Forum Discussion
Ya, so the limit is 6.
But "no problem" as long as you are summarizing on text fields which I assume you are ...
Just take two of your fields and make a formula - text field to concatenate them together like
new field [Customer Name and City]
with a formula
List([" ",[Customer Name], [City])
and then use that as one of your six levels of summary, so that will be a "2 'fer" like a "2 fer" the price of 1 deal.
But "no problem" as long as you are summarizing on text fields which I assume you are ...
Just take two of your fields and make a formula - text field to concatenate them together like
new field [Customer Name and City]
with a formula
List([" ",[Customer Name], [City])
and then use that as one of your six levels of summary, so that will be a "2 'fer" like a "2 fer" the price of 1 deal.
This solution saves my day. Thanks Mark :)