I have created a matrix table which does the following
- shows client groups and can +/- to show the clients within the group
- 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