Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
kamal_sanguri
Specialist
Specialist

Including all items in list as expression to chart(Pivot Table)

Hi,

I am trying to create a customized table with user selected fields and expression. But stuck... Is there any way to display all selected items as expression... I do not want to list them individually in expression.. What I am trying to do is I will update the list of expression in excel and once I reload the app it should update the chart with added expression in list.

Any help would be appreciated..

Thanks,


2 Replies
ecolomer
Master II
Master II

Here you have an example

kamal_sanguri
Specialist
Specialist
Author

Thanks for the reply.. I have already tried this and now I am looking for some better way.. I have more than 100 fields for expression and it is very difficult to list all of them and then write function for them.. Also it there is any new field is added.. I have to again include that in the list...

what I am looking for is.. something like this.. _metrics is the header of list

I have done this...

tbl.jpg

I want to do this...

tbl1.jpg