Thanks for the Reply, If you observe my Example, the Payment Type is not Static for all the user and payment Type has nearly 5000 types 🙁
Writing Pivot is a Challenge with out clear understanding.
Also by Writing Pivot I am restricting the Payment types.
When Ever a new payment come's in I need to Append it to the query.
Please check if any such scenarios occured for any of you ???