1. Home
  2. Forum
  3. Blazor
  4. Pivot field list fields caption

Pivot field list fields caption

hello and sorry for my bad english
I have a question regarding Blazor's Pivot component
Is it possible to rename the properties of the objects associated with the Pivot?
I have a collection of classes that I associate with the pivot data source.
The class is:

        public string CustomerId {get; set to; }
        public string CustomerName {get; set to; }
        public string CustomerCity {get; set to; }
        public string CustomerProvince {get; set to; }
        public string CustomerRegion {get; set to; }
        public string CustomerState {get; set to; }
        public string CustomerSector {get; set to; }
        public string AgentName {get; set to; }
        public string BrandName {get; set to; }
        public string DocumentTypeName {get; set to; }
        public int Year {get; set to; }
        public int Semester {get; set to; }
        public int Quarter {get; set to; }
        public int Month {get; set to; }
        public int Week {get; set to; }
        public int DayOfMonth {get; set to; }
        public int DayOfWeek {get; set to; }
        Public decimal amount {get; set to; }
        public decimal DiscountedAmount {get; set to; }
        public decimal Discount {get; set to; }

Is it possible to display the text "Customer code" instead of "CustomerId" in the FieldlList, or the text "Day of the week" instead of "DayOfWeek" etc.?

I searched in the documentation but without success

Thanks for the reply and for the excellent work done

Luca

Attachment: PivotFieldList_647d4834.zip

4 Replies 1 reply marked as answer
SN Sivamathi Natarajan Syncfusion Team June 29, 2020 03:13 PM UTC

Hi Luca, 
 
Thank you for using Syncfusion products. 
 
We have implemented your requirement and available in Volume 2 release which is estimated to be rolled out on tomorrow or within the week. So, we will update you the details once the release has rolled out. 
 
We appreciate your patience until then. 
 
Regards,
Sivamathi. 


SN Sivamathi Natarajan Syncfusion Team July 10, 2020 12:40 PM UTC

Hi Luca, 
 
We are glad to announce that our Essential Studio 2020 Volume 2 Release v18.2.0.44 is rolled out where the requested feature “To set caption for all fields” has been included and is available for download under the following link.  
 
  
To achieve your requirement to set the captions for the fields in the datasource please use PivotFieldMapping option in PivotViewDatasourceSettings 
  
For example:
  
< PivotViewDataSourceSettings > 
     <PivotViewFieldMapping>  
            <PivotViewField Name="CustomerId" Caption="Customer Code"></PivotViewField>  
            <PivotViewField Name="DayOfWeek" Caption="Day of the week"></PivotViewField>  
            <PivotViewField Name="Order_Source" Caption="Order Source"></PivotViewField>  
            <PivotViewField Name="Year" Caption="Full Year"></PivotViewField>  
            <PivotViewField Name="Semester" Caption="Half Year"></PivotViewField> 
      </PivotViewFieldMapping> 
</PivotViewDataSourceSettings> 
 
  
Meanwhile, we have prepared a sample for your reference. Please check the below sample link. 
 
 
 
We thank you for your support and appreciate your patience in waiting for this release.  Please get in touch with us if you would require any further assistance. 
 
Regards, 
Sivamathi.

Marked as answer
LU Luca July 17, 2020 02:41 PM UTC



I apologize for the late reply. Everything works perfectly, excellent components and support team! One question: can the format be specified in addition to the field title?

SN Sivamathi Natarajan Syncfusion Team July 20, 2020 02:15 PM UTC

Hi Luca, 
 
Currently, we don’t have support to provide format in field mapping. Kindly check the below UG for the available properties set in field mapping. 
 
 
Instead you can directly set format to any value fields by “PivotViewFormatSetting”. For more information refer the below UG link. 
 
 
Please let us know if you have concern. 
 
Regards, 
Sivamathi. 


Loader.
Up arrow icon