Pivot on Certain Dimension Value

[#1]

Hi,

I am currently building a large pivot table and am looking to add another dimension.

However I only want it to show for one Dimension Value, ie

Business Group > Service Line

Business Group > Service Line > Sub Service Line

So essentially I can pivot once more for one dimension value but this extra pivot won't appear for the other values.

Thanks,

James

[boorgura]

If you want to show Sub Service Line for just one Service Line (say XYZ), you can use a calculated dimension.

if([Service Line] = 'XYZ', [Sub Service Line])

** you can have the else part of the IF clause to populate blanks or leave it as is so that it will stay NULL