I have a KPI with a complex calculation that I have linked to a Sheet that I want to display the detailed data that the KPI is calculated from.
Specifically, the KPI calculates the data based on a single Site (Where multiple Sites exist) and I want the Sheet data to show only the data from the Site the KPI calculations are based on.
Is this possible? I'd imagine it would involve carrying a filter value from the KPI to the Sheet somehow.
