Thank you LSharm, I guess that'll have to do then :-)

Hi Robert, I'm not sure I understand your presentation variable solution, but that could just be me because I'm unfamiliar with using them. Your first tip worked :-) only I'm also using column selectors and my added columns disappear...because it's a different dashboard. Do you maybe have a solution for that as well?

Hello Robert, Thanks for your reply. I'm afraid I haven't been very clear in describing my wishes. I would like the original report to remain on the page and the detailed report to appear on the same page (in a different section/column/...). So I don't want to navigate to a separate page.

Thomas, Robert, Thanks for your replies, but unfortunately this hasn't brought me any closer to what I'm attempting to do. I'm just going to assume that conditional column headers are a bit too farfetched and leave it at that.

Hello Robert, "I can't figure out how to give the same column that's used twice a different name" should actually be "I can't figure out how to give the same column that's used twice a different name depending on the supplier" since I need to give them a different name if the supplier is named 'unknown' (while they contain…

Hi Robert, Thanks for your reply. Two separate columns have been merged together into one using a case when statement (so the column Harvest/FC actually consists of the results of two measures). Otherwise, the pivot table will show me the columns Harvest, Arrival, FC and Sales for each supplier and that's exactly what I…