Custom Function Field in Report

[Dinh Nguyen]

Can i using Function Field custom column_label ! I tried custom a Function Field but it work with column_name ! If it impossible so is there any other way to custom column_label for Report ?

Please help me ! Thank you so much

[AndersBGS]

Hi Dihn,

the function field is in general utilized for making a calculation and return the value for every single record in the range you specify.

feom your information., I’m not sure that i understand what that you are trying to obtain?

can you give some further explanation?

If my answer have helped towards a resolution, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Dinh Nguyen]

@AndersBGS  thank you so much for reply me ! 

I want to have a report like this ! I used Function Field and it's worked because the value is string

But when i use Function Field for this field it's not worked because it's options

desire report : C&A, C&D, C&N, C&P

reality it's work with column_name : c&a, c&d, c&n, c&p

[AndersBGS]

Hi @Dinh Nguyen ,

What you are looking for is not possible. The best possible solution is, to have data in to different columns which then can generate a multi-level pivot table. So in general, you should have one field containing the the vertical value set and one field containing the horizontal data set. 

If my answer has helped to answer your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders