Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sum({$<[Sale History 2022.Customer]={"Publix"}>}[2022 Qty Sold])
Can someone please tell me, how to make KPI label change based on what is in the formula? If formula above says, "Petco", I need to see KPI with 10,000 and Label says "PETCO". Is this possible? Thank you.
I don't fully understand how you will change what's in the formula- I would think you will use a variable in your formula like $(vStoreName) and that will have either "Publix" or "Petco". You will use that same variable wherever you want it to be in effect.
Hope that helps!