Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yes, it should follow the format below:
sum({1}field)
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!
I think is
=(Sum({1}[Cases-Verified:])/Sum({1}[Cases-Total:]))
Yes thats correct! Thank you!
Right, did it work?
Yes thank you!