Forum Discussion
cumulative total based on text field
hmmm not sure why you are doing merge, you should be using append, at end of the day, you will get one table that will something like this:
Table 1
Term count
Apples 10
Oranges 5
Grapes 7
Oranges 15
Grapes 6
Pears 3
now in your table visual, put two column in value:
term and count, and use sum aggregation for count and that will give you the result.
**Don't use merge, append please
Super Userhmmm not sure why you are doing merge, you should be using append, at end of the day, you will get one table that will something like this:
Table 1
Term count
Apples 10
Oranges 5
Grapes 7
Oranges 15
Grapes 6
Pears 3
now in your table visual, put two column in value:
term and count, and use sum aggregation for count and that will give you the result.
**Don't use merge, append please
Microsoft EmployeeHi FuzzySteve,
Have you tried the solution provided by parry2k above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here. :smileyhappy:
Regards