Interactive tool

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

Transformation

Accepted answers

All comments

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:

Select name and description.yxwz

unknown

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

unknown

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.

Allocated.xlsx

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.

Select name and description - Updated.yxwz

unknown

Sure @DataNath Thanks a alot

unknown

@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?

Run as app.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703