Hello, It's been a long day and trying to figure this out, can someone assist please.
Data:
Filters: Year (2014, 2015) Month (Jan...Dec)
| Computer | Total Average % Deleted Files (For all data) | Avg Current MTD (July 1 to Today()) |
|---|
| A | 20 | 2 |
| B | 30 | 3 |
| C | 20 | 2 |
| D | 50 | 2 |
-- TOTAL Current Avg MTD = 9
***Don't mind the data, just entered whatever***
What I am trying to achieve:
Expression showing the Total Current MTD Number until I filter to the specific computer...
Currently, If I filter to a computer the data changes to match the total for all the data..
Sorry if this is confusing, I cannot post the QV file, I will try and give as much info as possible.
=Num((Sum(<$={"$(= '>=' & date(MonthStart(today())) & '<=' & date(Today()))"}>} distinct Computer)/(Count(Sum(<$={"$(= '>=' & date(MonthStart(today())) & '<=' & date(Today()))"}>} distinct Computer))/100), '###.##%')
