Hi,
I have a Flat data as below.
======================================================
Id Company Company_Address Company_Ph Emp Name Income $
1 ABC SantaClara 123-456-7891 David 100,000
2 ABC SantaClara 123-456-7891 Naveen 200,000
3 ABC SantaClara 123-456-7891 Jane 300,000
4 ABC SantaClara 123-456-7891 Sonu 400,000
5 DEF Austin 111-222-3333 Allan 500,000
6 DEF Austin 111-222-3333 Donald 600,000
My Pivot Criteria:
=============
Measures Column = Income$
Row columns = Company
Can i show remaining static columns such as Company_Address Company_Ph as a properties on my left hand side or somewhere. These are attributes of my group column .In this case, Company_address and Company_ph are attributes of company column?
Expected Output:
=======================
Income$
David 100,000
ABC SantaClara 123-456-7891 Naveen 200,000
Jane 300,000
Sonu 400,00
Can this be achieved in XAMLPIVOTGrid?
Thanks,
Valliappan
Hello Valliappan,
Thank you for your post. I have been looking into it and can say that you can add “Income$” in the Rows collection and the “Company”, “Company_Address” and “Company_Ph” in the Columns collection of the XamPivotGrid. They will appear in the same order you add them there.
Hope this helps you.