Interactive tool

[Inactive User]

Hi, team. 

I have 3 columns: Name, Number and Description in the file. 

I need to select the Name and Description, so that I need to get the sum of column Number respective to the name and description. 

Suppose if I select Name, and select the description then I need to get the sum of number which is related to the name and description

Please help. 

It need to be done in interative tool because we need to select the name and description to see the number column

[DataNath]

How does this look @Inactive User? Hopefully I've understood the ask correctly. The Summarize tool sums all combinations of Name + Description and then the app allows you to pick which Name and Description you want to see the sum of:

[Inactive User]

Thanks @DataNath I will go through and let you know. Thank you so much

[Inactive User]

Hi, @DataNath I tried to apply samething but i am not getting it. 

Could you please help me with the same this to the below data. Please. Thank you.

[DataNath]

Hey @Inactive User looked like the [Name] field in the original data sample you provided had a space in it so wouldn't read properly when you added the new data in. I've updated the app now. Will users know which descriptions belong to which names? At the moment all descriptions will show, rather than only relevant values as the app isn't chained. Let me know how this is.

[Inactive User]

Sure @DataNath Thanks a alot

[Inactive User]

@DataNath hi, I am not getting out put in this cross tab. It has input but when I run the workflow it does not have any output. Please help

[DataNath]

Hey @Inactive User there shouldn't be any output there. The top two streams including the Summarize and Cross-tab tools are just there to dynamically populate your dropdown options. I thought the point of the request was user-selected filtering and so this should be ran as an app, rather than as a workflow itself. If you hit the magic wand button and run it as an app, is that what you're after?