Forum Discussion

brose's avatar
brose
Regular Visitor
6 years ago

Filter by Sub-Totals in Matrix

Hello Everyone - I'm having an issue with creating a filter on sub-totals in a matrix.  The current matrix has the shown values below:      My goal is to filter on the total sum of planned h...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi brose ,


"What I want to happen is for the next 8 weeks show me anyone who has less than 100 hours and only Bryan should show up in the list, Lisa and Robb Should fall off.  "
Do you mean you want to filter by sub-total, such as "sum of Bryan" , "sum of Lisa", "sum of Robb"?

 

which table does your each column come from?
And what's the relationship between these tables?

Please give me a sample data model.

Best regards,
Lionel Chen

brose's avatar
brose
Regular Visitor
6 years ago

Correct I want the "sum of Bryan" , "sum of Lisa", "sum of Robb"? and then be able to filter by quantity.  Example.  Anyone with more than 100 hours planned over the next 3 calendar weeks don't show up in the view.  Below are the fields I'm using.  Tables are Person (Import)

Planned Hours

Begin Date