Forum Discussion
Total Lines, based on tables
Hey!
I have 5 pages in my report, all using a table (a visual object) with similar layout, only different input from the raw data. All these tables have one thing in common, they have a total line on the last column. Is there any way to capture this total line so I can mulitply them into a new table? I can't use the raw data it self, cause it has to many lines.
Hi,Gealnath .I am glad to help you.
As I understand your description, you are trying to summarize the final aggregated result (Total value) of a visual in each page into the same page for presentation.
Unfortunately, the Total value in a visual cannot be passed across pages. You need to simulate the calculation environment in visual and write a measure /calculate column that has the same effect ,summarize them in a table for display.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi,Gealnath .I am glad to help you.
As I understand your description, you are trying to summarize the final aggregated result (Total value) of a visual in each page into the same page for presentation.
Unfortunately, the Total value in a visual cannot be passed across pages. You need to simulate the calculation environment in visual and write a measure /calculate column that has the same effect ,summarize them in a table for display.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Gealnath
Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.
Thank you for your understanding!
Hi Gealnath,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Hi Gealnath,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
