Skip to Content

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


I select Profit divided by Sales


I wondered about formatting and noticed the following:


There is no percentage.

Now I can create visualizations using the Profit Ratios.


I created storyboards.


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