Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having an issue with my count for matches values. As you can see below the count seems to be including an additional column (highlighted in yellow):
The expression I am using is for this pivot table is:
Row: =IF(OrderPODDateYear>2017,PODDATEMONTH)
Column: =If(Match([PriorityLevel],'AOG','Routine'), PriorityLevel)
Measure: =count(DISTINCT OrderID)
Is there something I can do so it only returns Routine and AOG figures?
Thanks
Hi,
Try just filtering on the expression, like this:
=count(DISTINCT {<PriorityLevel={"=Match([PriorityLevel],'AOG','Routine')"}>} OrderID)
Hi,
Try just filtering on the expression, like this:
=count(DISTINCT {<PriorityLevel={"=Match([PriorityLevel],'AOG','Routine')"}>} OrderID)
THANKS!
it worked
You're welcome!
to simplify, this will also work:
=count(DISTINCT {<PriorityLevel={'AOG','Routine'}>} OrderID)
Thanks again!