Excel Power Pivot Add Calculated Measure to Row

[elleb]

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.

[romperstomper]

Why do you want three values all in one column?

[elleb]

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

[romperstomper]

Yes, but why do they need to be in one column? That just makes it much harder to actually use the information for anything.