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)
[TABLE="width: 216"]
<tbody>[TR]
[TD]Count of Question[/TD]
[TD]Month[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year[/TD]
[TD="align: right"]Jan[/TD]
[TD="align: right"]Apr[/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]89[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]
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)
[TABLE="width: 216"]
<tbody>[TR]
[TD]Count of Question[/TD]
[TD]Month[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year[/TD]
[TD="align: right"]Jan[/TD]
[TD="align: right"]Apr[/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]89[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]
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