Create a new Column – Wholesale_Price. You have the Unit Price column – which is a Sale price before the discount. For the Wholesale_Price column, calculate the Price after the Discount. NOTE: Discount column should be in % format. This is a discount % applied on Unit Price.

5. Create a new Column – Wholesale_Price. You have the Unit Price column – which is a Sale price before the discount. For the Wholesale_Price column, calculate the Price after the Discount. NOTE: Discount column should be in % format. This is a discount % applied on Unit Price.

6. Create a new Column – Discount_Size – which is a difference between Unit Price and Wholesale_Price.

7. In the new Tab. Create a Table visual with the breakdown of Discount_Size by Product Sub Category. Use conditional Formatting for Discount size. Use icons with the default percentage breakdown ( 0-33, 33-66, 66-100). Where 0-33 => green up arrow, 33-66 => orange flat arrow, 66-100 => red down arrow. Make sure it looks the same as in the example below

Last Completed Projects