0

I'm having a list of orders and orderlines and would like to be able to Count the number of orders by different filters, e.g. by item, payer, warehouse. My issue is that i get the number of lines calculated. I've tried two different methods:

This:

=calculate(DISTINCTCOUNT([Ordernumber]))

And this other:

=calculate(COUNTROWS(SUMMARIZE('TableName';[Ordernumber])))

PivotTable

Gustavo Morales
  • 2,614
  • 9
  • 29
  • 37
Jan Boldt
  • 135
  • 10
  • The behaviour of the rows looks correct: you have one distinct OrderNumber for the OrderNumber 351532 and orderline 10. The Sum row should show 4 though. Is the Sum row one you have added manually with an Excel formula SUM(D2:D8)? If it is then change your pivot table to show totals instead. – Rory May 30 '16 at 17:19
  • @Rory, the sum is from the pivot table – Jan Boldt May 31 '16 at 08:01
  • The pivot total should show 4 for DISTINCTCOUNT([Ordernumber]) unless you have filters in your pivot table. – Rory May 31 '16 at 09:28
  • @Rory, I do have filters in my pivot table, one could be Item another Supplier. It differs, is it possible to get this kind of dynamics into the pivot table. – Jan Boldt May 31 '16 at 10:37
  • I tried to insert the DISTINCTCOUNT[Ordernumber] in the pivottable using by "Insert calculated item" and then it worked – Jan Boldt May 31 '16 at 11:47

0 Answers0