I really don't know how to describe this, so I had trouble with a good subject, or searching it out, but...
I have a grid with a lot of numbers. In some of the columns, the value is repeated (identical) for each row. I'd like to show those only once as some kind of header or summary row, but without their own grouping, per se, and without any kind of aggregate function working on them. They all belong to the group that contains them. Does that make sense?
Perhaps this picture can help:
Notice how all the values in "Volume," "Volume Last Week", "Volume Last Year" are the same? I'd like them to show up only for the "Region" (which is the grouping containing this set). I'm hoping this is easier to do than to explain. 😅
Thanks in advance!
Brad.