i m trying to create the top N and Bottom N for the campaign pipeline.through combined sets.
I want the top N and bottom n one below the other, for each region at the campaign levels.attached is the workbook.
steps i followed.
Below is the desired look
You need to use a calculation to split out the top and bottom.
I created BottomOrTop:
If [bottom] THEN "Bottom" ELSE "Top" END
and added that as a dimension. See attached.