Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
megan_deboer
Partner - Contributor II
Partner - Contributor II

KPI Chart not effected by filter selection

    I'm wondering if its possible to make a chart or KPI that won't be affected by any filter selection on the sheet? Is this possible?

Thank you! Megan

6 Replies
marcelviegas
Creator II
Creator II

Yes, it should follow the format below:
sum({1}field)

megan_deboer
Partner - Contributor II
Partner - Contributor II
Author

Thanks Marcel!

I'm working on a calculation for the KPI: =(Sum([Cases-Verified:])/Sum([Cases-Total:]))

Where would I place the sum({1}field) within the formula?


Thank you!


silvacarlos
Creator II
Creator II

I think is


=(Sum({1}[Cases-Verified:])/Sum({1}[Cases-Total:]))

megan_deboer
Partner - Contributor II
Partner - Contributor II
Author

Yes thats correct! Thank you!

marcelviegas
Creator II
Creator II

Right, did it work?

megan_deboer
Partner - Contributor II
Partner - Contributor II
Author

Yes thank you!