Capture.PNG
Hi, firstly thank you for your time.
Hopefully you will see from the screen shot what I'm trying to explain.
If we use Maint Plan 6033610 as the example. You can see that the Plant Section 19 occurs 8 times, 19B twice and 19G once.
With the Grand Total being 11. I want a Grand Total or just Total to indicate 3 - the number of unique occurrences e.g. 19, 19B & 19G.
How is this possible?
Note: I don't actually need the number of Plant Section occurrences, just that it occurs at least once. However if this doesn't need to be changed for the solution then just leave it as is.
Hopefully I have explained it enough for you to understand.
Any help would be greatly appreciated as I'm scratching my head a bit with this one.
Thanks in advance,
Olly
Bookmarks