on 02-10-2016 12:01 PM
Hi All,
We have this requirement where we have to provide a user prompt with comma separated values in input.
Like:
Please enter Type: ABC; XYZ;
Then we have to show value for these type in horizontal table rows.
If user didn't provide any input, those rows should stay hidden. This table contains other rows too which are fixed.
Any help will be appreciated.
Regards,
Shrutika
As shown in the following image.
First row total will be sum of all the values in the first column except date.
And the 3rd last row 'Total credit lines available' will be sum of values of last 2 rows.
I want to dynamically hide/show the last 2 rows, depending on the user input from the prompt.
Regards,
Shrutika
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
One Option is to use two tables.One for last two rows.
Right click on the second table Format-table->General-Checked the option Hide when formula is true and put your user response condition there.
sample =UserResponse("Year")=""
If user will not enter any value then second table will hide.
After that use relative position to bound these two tables together.
Amit
Hi,
Share your table screenshot.
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.