Here is my initial observation on the given dataset LTD Sales
The data looked complete with column headers and with no null and duplicate values, no blank rows in between the columns
Creating a custom column - To generate Revenue as per State create a custom column.To create a custom column Go to Add column, click on custom column. A pop up window an will appear. In the new column name type Revenue and In custom column formula type Quantity column multiply with Unit price column i.e. Creating a custom column Revenue using two columns "Quantity" and "Unit Price" and Click OK.
To create new column as per the above condition First Create custom column for Add column tab and type formula as below and click OK
To create new column "Product type" go to "Add column" tab click on Conditional Column apply conditional formatting on "Product Category" as below and Click OK.
Insights from the Dataset