Dear Guru
Please help for this as attached file.
I need to count customer type as green table when show same column B need to show only 1 and to have total sub = sum of them but when I use pivot formula , it's show summary of record of customer type pls see in attached file, as i do i can get by need but i need to column J (Sum to show in row panel below each company column but i can't do. i need as green table format but need to show from pivot. how can i do this. pls suggest .
Bookmarks