Matrix Table Results

I have created a matrix table which does the following

  1. shows client groups and can +/- to show the clients within the group
  2. within the clients within the group can +/- to show the jobs for that period

when i drag in the total sales it is showing all jobs for all clients with blanks.

when i just do a matrix without the total sales it filters out correctly.

how do i fix it so it only shows the jobs for the current period and not all jobs

Please share a copy of the PBIX to help better solve your question. There are several things that may be causing this error, but without seeing the PBIX it is harder to tell.

Thanks
Jarrett

Enterprise%20DNA%20Expert%20-%20Small