Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you calculate percentages for a non-numeric object
- Thread starter onder
- Start date
Hello Onder,
If your subject is non-numeric (let's say field1), I suspect you will do a count on them. So add a measure in your universe that reads as Count(field1). Be aware that the returning measures are related to the dimensions you retrieve in your query.
So if you count for instance customerorders and select date as dimension you will see the number of orders per day. If you now drag in sales manager, the result will be number of orders per day per salesmanager.
Establish the percentage by creating a new variable (format %) that calculates Count(field1)/Sum(count(field1)) in a new column. See chapter 15 of the .pdf user's guide for calculations within specific contexts.
If your subject is non-numeric (let's say field1), I suspect you will do a count on them. So add a measure in your universe that reads as Count(field1). Be aware that the returning measures are related to the dimensions you retrieve in your query.
So if you count for instance customerorders and select date as dimension you will see the number of orders per day. If you now drag in sales manager, the result will be number of orders per day per salesmanager.
Establish the percentage by creating a new variable (format %) that calculates Count(field1)/Sum(count(field1)) in a new column. See chapter 15 of the .pdf user's guide for calculations within specific contexts.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question