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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

%

Status
Not open for further replies.
MSTRDUDE

MSTRDUDE

Programmer
Feb 26, 2004
6
US
Hi
i am new to the tool and was trying to make a simple report. Basically all i have on a report is customer segment and transaction count. transaction count is a number. I want to display it as a percentage (of the whole). Is there any option in MSTR which lets me do that straight away like the cells option in excel??? how else could i go about it?
Any help appreciated!!
Sid
 
Sort by date Sort by votes
I want to display it as a percentage (of the whole)"

Then you will need total Transaction Count along with Transaction Count for each segment. With the two metrics, you create a compound metric where [Segment Transaction Count] / [Total Transaction Count]. Set this metric format as a percentage.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top