Displaying Totals Dynamically using Selector...how to do this?

[Former Member]

Thanking you in advance for your kind guidance...

My requirement is to show Totals for each label.

In the case below, 15.

    Problem is that my original data does not have the total.

    So I added the sum formula in the destination range.

   Then I get the warning like this and it is not working...

     In other words, I want to display the total of column dynamically...

[former_member182541 · Accepted solution]

Based on your scenario, I have built one sample take a look at the snapshot and the attached file.

The file will be in .txt format change that to .xlf.

sample.txt.zip

[Former Member · Accepted solution]

Wow thank you. Let me take a look. I will get back to you.

[Former Member]

Hi Suman,

So basically you did 2 things?

1. Make 2 selectors for Table & Total

2. On the 1st selector, Selected Items is Dynamic and is linked to the Cells containing Total.

[former_member182541]

Yes you have nailed it. When things doesn't work directly, look for workaround.