Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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