mahmed1
Well-known Member
- Joined
- Mar 28, 2009
- Messages
- 2,302
- Office Version
- 365
- 2016
- Platform
- Windows
Hi All
I have a table that is set up like this etc
2017 2018
Jan Feb Mar Jan Feb Mar
Test1 5
Test2 10
Test3 20
This table has data stored every month with the amount of tests done
I have a pivot table that just filters to give me which months and years are selected from a slicer in this format (Ignore the values)
<tbody>
</tbody><colgroup><col><col><col></colgroup>
I need a formula that looks up my table and gives me the total amount of tests done for that selection
so on my slicer - if I selected 2017, 2018 and I selected Jan and Feb
I want to retrieve the total tests done from this table
Can someone please help me with this
Thanks
I have a table that is set up like this etc
2017 2018
Jan Feb Mar Jan Feb Mar
Test1 5
Test2 10
Test3 20
This table has data stored every month with the amount of tests done
I have a pivot table that just filters to give me which months and years are selected from a slicer in this format (Ignore the values)
Count of Question | Month | |
Year | Jan | Apr |
2018 | 32 | 89 |
<tbody>
</tbody><colgroup><col><col><col></colgroup>
I need a formula that looks up my table and gives me the total amount of tests done for that selection
so on my slicer - if I selected 2017, 2018 and I selected Jan and Feb
I want to retrieve the total tests done from this table
Can someone please help me with this
Thanks