I want to create labels for Sales, depending upon the percentiles they fall into. I am using the formula
IF ZN([Sales]) <= ZN(PERCENTILE([Sales],0.10))
THEN "0-10 PERCENTILE"
I am getting an error "Cannot mix aggregate and Non-Aggregate functions". I don't want to go back to my data to create additional columns. Any suggestions?
Change it to:
then "0-10 percentile"
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...