Hi, I need to create a pivot table (?) that will have dates in rows, shops (A/B) & their addresses in columns and sum of products as values.
After that, I need to create summary columns with Min and average values for shops A.
This should look somehow like on the screenshot
I'm able to somehow recreate this view via PowerQuery, but the thing is that I'd like the end user to be able to also drill down to product level and see how prices vary between shops on more granular level and that's where I'm stuck - I do not see the option to put these Min/Avg columns at the end of pivot table, it just creates two columns for each shop once I put a measure in values
How to implement this in Pivot Table/PowerPivot? I've been looking at CUBE formulas but having hard time to adjust them to this case, but maybe I'm completely off and there's simpler/another way to this?
This needs to be in Excel, not PowerBI
Thanks in advance for any suggestions!
After that, I need to create summary columns with Min and average values for shops A.
This should look somehow like on the screenshot
I'm able to somehow recreate this view via PowerQuery, but the thing is that I'd like the end user to be able to also drill down to product level and see how prices vary between shops on more granular level and that's where I'm stuck - I do not see the option to put these Min/Avg columns at the end of pivot table, it just creates two columns for each shop once I put a measure in values
How to implement this in Pivot Table/PowerPivot? I've been looking at CUBE formulas but having hard time to adjust them to this case, but maybe I'm completely off and there's simpler/another way to this?
This needs to be in Excel, not PowerBI
Thanks in advance for any suggestions!
