Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1355
XAMPivotGrid - Displaying some properties without summarizing BUT just as attributes
posted

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

  • 138253
    Offline posted

    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.