Matrix Visualization with data from same source filtered by 2 separate date filters

kits_kat

New Member
Joined
Jun 14, 2021
Messages
1
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
I have a data source with sales data by store. Columns in this data include actual sales, forecasted sales, week date, weekending (saturday), region for the store, and which warehouse the store received the sold items from. I need to create a matrix visualization in which the user can filter the average actual data by whichever dates they choose with a slicer and the sum forecasted by whichever dates they choose. The dates can be the same or differing but the dates displayed must be those of the forecasted. The average dates will be in the matrix as well, however they will be matched with the weekday.

The actual data is an average of selected weeks from a slicer.
The forecast is the forecasted value for the displayed weeks
The actual data is matched by day of the week
The data lives in the same source, however I have 2 copies in order to filter them by separate dates and not have the filters affect one another.

What I have
Screen Shot 2021-06-14 at 3.28.32 AM.png

What I desire (the actual week column is to show the data being aggregated)
Screen Shot 2021-06-14 at 3.28.02 AM.png


I'm not sure how to accomplish this nor if this is an advanced or beginner skill. Any assistance or direction is greatly appreciated! Direction in other forums to find answers is also appreciated. For some reason I'm unable to post or make a microsoft forum account.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,141,402
Messages
5,706,245
Members
421,433
Latest member
yash0468

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top