Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
You can use the Concat() as Calculated Dimension. Check the attachment for solution, is that you require.
Hope this helps you.
Regards,
Jagan.
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.
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
Hi,
You can use the Concat() as Calculated Dimension. Check the attachment for solution, is that you require.
Hope this helps you.
Regards,
Jagan.
Thanks, that helps!!