Excel Power Pivot Add Calculated Measure to Row

Good Morning all,

I wondered if someone could help with the below problem.

I have a query where I have unpivoted columns and loaded this to a data model/table that is outlined in the following way.

ExcelHelp.png


I have loaded this to a pivot table with Area and Description in the rows and Attribute in the Columns, I have then calculated a measure that divides the Refunds by Total sales to give me a %. However I want to add this to the row area so that each area shows Total Sales, Refunds and % Refunds for the date all in one column.

I am fairly new to data modelling so I apologise if its a simple fix but any help would be appricated.

The data is updated regularly and I want to create a table that summarises the changes based on each date, so Sales, Refund and % Refund for 01/01/2024, then 02/01/2024 etc