Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
TammyPowlas
Active Contributor

I am still using a sample dataset of sales, profit by category, region and order date.

First I create a calculation that looks at each record to determine profitability:

If the profit ratio is greater than zero, then it is profitable; otherwise it is not.

Next I can visualize how this looks:

I can create another calculation showing the percentage of total:

This is how the table looks:

Next I can send the table by e-mail:

I select Keep table totals:

Then I can send by email:

I can open in Excel:

I notice some rounding differences between Excel and Lumira.  It looks like Excel rounds up, but Lumira does not.

Also, the grand total is lost in Excel. 

Labels in this area