Skip to Content
author's profile photo Former Member
Former Member

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

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...

warning.PNG (16.4 kB)
Capture.PNG (2.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 11, 2016 at 05:54 AM

    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 (7.5 kB)
    1.PNG (74.0 kB)
    2.PNG (74.1 kB)
    3.PNG (73.1 kB)
    4.PNG (72.6 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2016 at 07:06 AM

    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.


    Capture.PNG (84.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.