Summary Report Filters

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
  • (Edited)
I am having difficulty on a Summary Report and multiple filters.
I get exactly what I want when selecting the Status




But when I add in the secondary layer of filters to get to the ROM's & Status I want..

It returns the following... I am clueless why this is happeningĀ 



Photo of Hans Hamm

Hans Hamm

  • 710 Points 500 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Can you say in words what you want the 2nd set of filters to do?
Photo of Hans Hamm

Hans Hamm

  • 710 Points 500 badge 2x thumb
Mark the second set of filters is to get down to the ROM. Basically I want to filter by the status of the project (1) and then by the ROM name (2).
Photo of Hans Hamm

Hans Hamm

  • 710 Points 500 badge 2x thumb
Mark... I do not remember having to break down the filters this way, but finally figured it out
I had to keep segregating the parameters away from each other


(Edited)
Great, so you are good now.
Photo of Hans Hamm

Hans Hamm

  • 710 Points 500 badge 2x thumb
Yes, thank you. But it does lead to another question, if I may. On the last screen shot; it is stating where the Start Date is during the next 1 week. I am okay with this one.
But what if I wanted the Start Date to be 2 Weeks? Don't want week 1 & 2 together. (is what during the next 2 week(s) gives me)
Example: 1 Week is 8/13/2018 and Week 2 would be 8/20/2018
if you want to include the week after next week, but not next week, then you use the two filters

date is during the next 2 weeks
date is not during the next 1 week.
Photo of Hans Hamm

Hans Hamm

  • 710 Points 500 badge 2x thumb
You are DA MAN! Thanks Mark I do appreciate it!