My name is Ashwin Gour. I have recently joined this group.
I am working on a Superstore dataset. And wondering what would be Profit ratio's formula given sales, discount and shipping cost, quantity ordered Product Base Margin and Sales.
I googled it and got to know that its Profit/Sales. Is it correct ?
And I too have second question I want to split up the regions into four sub category such as Central, West, East and South. Do I have to do it in the data source itself or need to do something else?
like this dashboard Tableau Public
Please do let me know your thoughts. Thank you.
The formula should be if sum(sales) = 0 then 0 else sum(profit)/sum(sales) end.
To break into regions, put region onto columns and sum(sales) onto rows.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...