I did try to search for a similar post but couldn't find anything I thought that would be the case but wasn't sure if someone had come up with some magic way of doing it. Thanks.

I do trust him!! I wasn't sure if that was in relation to variables which is what we had done originally so thought I'd try the filter instead if that worked but guess not...

Sorry, I've only just had chance to come back to this! So if I've interpreted it correctly we should be able to have 2 tiles on the same report, one where the column formula for example is: FILTER("Headcount" USING "Employee Type" = 'Permanent') And another tile where the formula is for example: FILTER("Headcount" USING…

Thanks Gianni For example each tile has a type of employee (eg temporary/permanent) so the metric on the tile is Permanent headcount. The detail report shows all the details for the employees and the drill should only pass the relevant metric, so only show me permanent people When drilling from tile 1, temporary from tile…