I am using sample data from Training Superstores which is contained in an Excel file.

I want to calculate the profit ratio (profit divided by sales) to see which customer segment and region is doing well.

First I acquire the data and then select Calculate > New Calculated Measure

/wp-content/uploads/2013/12/1afig_351000.png

I select Profit divided by Sales

2calc.PNG

I wondered about formatting and noticed the following:

3formatting.PNG

There is no percentage.

Now I can create visualizations using the Profit Ratios.

4createvisualizations.PNG

I created storyboards.

5storyboards.PNG

Then I published to the cloud

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply