Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
4 years ago
Solved

Matrix Running Total per Month (Example file included)

I have a matrix that shows values per month... the predicted heacount, available laptops and then remaining laptops (laptops - headcount).  Is there a way to get a running total for the remaining lap...
Need Help
StuartSmith's avatar
StuartSmith
Power Participant
4 years ago

Thanks, that worked as expected.  I then decided to duplicate the full report tab into Q1, Q2 & Q3 and then simply show the months data for those quaters. Q1 works perfect, but for Q2 & Q3, then figures dont carry across and simply restart.

 

As an example, at the end of Q1, there are 24 laptops remaining.

 

Then for Q2 it should say that there are 24 Remaining Laptops,but the "Total Laptops" value has reset.

 

and the same with Q3?  I thought simply duplicating the tab and filtering the months would work, but I guess not ğŸ¤”  Iwill try and figure it out, but any help is appreciated.

 

Updated Demo File with Q Tabs. 

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, StuartSmith 

Please still use the formula I provided above, but replace the ALLSELECTED function with the ALL function.

Result:

Please refer to the attachment below for details.

Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.