One heading for two dimensions in pivot table

[#1]

I'm trying to create one heading for two dimensions in a pivot table. I've attached the model. Above the dimensions

1)0-5,

2)6-9,

3)>10

I want to put a heading,Thresholds - like a merged cell.

For now I've left those headings blank

A graphic representation of what I would like to do.

TESTCategories	TESTMetric	TESTDescription	Thresholds			sum(Amount)
Clients	Limits	Information on number of incidences	1) 0-5	2) 6-9	3) >10	12

Any ideas?

[#2]

Hi,

0-5, 6-9, >10 etc. must be same field (range of days, months etc.)

We can create such ranges for same field.

Then, u will get Common Heading for 3 difft columns.

I don't know if u hv specific requirement for creating 3 independent columns for this.

[#3]

Ho would I do the common heading. If I do what you suggest then the thresholds 0-5,6-9,>10 appear in a column, as per attached model

[jagan · Accepted solution]

Hi,

You can use the Concat() as Calculated Dimension.  Check the attachment for solution, is that you require.

Hope this helps you.

Regards,

Jagan.

[#5]

Thanks, that helps!!