Epicor ERP How to create BAQ Pivot to count Customer Sales Order

[@aberdeenmeadows]

This was the BEST explanation of using PIVOT I have ever seen! So simple, and easy to understand.

[@shizar_ytb]

Thank you! This was amazing

[@dineshahir100]

In my case New pivot Columns are Grouping. how to Remove Grouping.

[@erplearningnow]

You can try to use distinct on query option?