2 Replies Latest reply on Jun 20, 2018 9:52 AM by monica.tran

Worksheet with Filter to Create "Combine Sets" and Grand Total Help

monica.tran Jun 19, 2018 5:34 PM

I want the user to be able to choose what suitcases they want to combine items or see the unique items of the suit case by using parameters and then calculate the total weight.

So far, this is what I have with my example data. My actual data is huge and have to be confidential.

Ideally, I want just the items, weight, and total weight visible. However, my makeshift tool needs Suitcase Name to work. Please comment if you need clarifications.

Thanks!!!!

example.twbx 30.4 KB

1. Re: Worksheet with Filter to Create "Combine Sets" and Grand Total Help

Mavis Liu Jun 20, 2018 12:08 AM (in response to monica.tran)
Hi Monica,

I'm not sure if I'm interpreting your question correctly, but maybe you can go to the analytics pane and select totals, row grand totals:

Have attached the workbook.

Thanks,

Mavis

example (1)_v10.5.twbx 67.2 KB
Like Show 0 Likes(0)

Actions
2. Re: Worksheet with Filter to Create "Combine Sets" and Grand Total Help

monica.tran Jun 20, 2018 9:52 AM (in response to Mavis Liu)

Thanks Mavis for the reply. I am just gonna play around a bit.

But basically, I want this result:

Which was done by using Sets and Combined Sets, however, I want parameters to be in placed so users that use the dashboard can decide what two or three suitcases they want combine or RIGHT/LEFT join them.
Like Show 0 Likes(0)

Actions