Hi I'm fairly new to PowerPivot so I'm sure one of the experts has a good answer for this.
We have customer accounts that have service codes attached to them…i.e customer 123 could have service code 1,2,3,4,5 etc..
What I want to do is show counts where a customer has service code(s) but doesn't have other code(s).
For example, maybe I want to show how many active customers have service code 1 but don't have service code 4 and 5.
Is there a simple way I can do this?
Also I want to create this to allow for the user to choose which codes to select to compare.
I tried using slicers but that doesn’t seem like an option.
This should be easy to figure out I would think but I’m struggling.
Anyone have a recommendation to point me in the right direction?
Thanks
Bookmarks