It's my first day building a dashboard and not surprisingly I've run into a formula i can't work out.
I have created a pivot table that shows certain selected products that i want to look at. I'm now trying to determine a way to return the number of distinct accounts (accountnum) regardless of my current selections that had sales over $1.
I have tried many things but the below two expressions are the closest i could get. If i do not filter my pivot table the column total for the first formula is the number i am after (250).
Count(TOTAL DISTINCT (accountnum)) //shows total products for pivot table selection (returns 100)
Count({1}TOTAL DISTINCT accountnum) //total accounts for every product in the system, not all these had sales (returns 1000)
I might also need to build in the variable month=Feb etc if you could also help with that.
The end goal being to show the percent of total accounts that sold the preselected items.
Something like: Count(TOTAL DISTINCT (accountnum))/ some formula.
