2 of 2 people found this helpful
You can pivot your data as in the screen below i.e. leaving ID1 and ID2
There after Go to your sheet and put your pivot field values in columns , and ID1 and Pivot Field Name in Rows and the count(ID2) on text.(( see below ) . if this answers your question , mark this as Correct answer so that it does not remain as unanswered question . Let me know if you have any further questions.
Thanks a lot, it works!
One more question. If I want to use parameter to swap between count (id2) and id2 (it self), how do I do that? Now I get the error says about aggregate and non-aggregate.
Thanks for your help.