Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Subtotal columns in workspace freeform tables

Avatar

Avatar
Give Back
Level 2
marting29150335
Level 2

Likes

9 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Contributor
Shape 1
Validate 1
View profile

Avatar
Give Back
Level 2
marting29150335
Level 2

Likes

9 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Contributor
Shape 1
Validate 1
View profile
marting29150335
Level 2

28-06-2018

Often we use the report filters in order to filter out specific groups of items in a freeform table, however applying this filter does not have any impact on the figure shown in the column total. The column total accounts for all item totals including those not included in any eventual filters. We have use cases with many of our users where it would be more useful for them for this total to be a subtotal (i.e. total of only items that are included in the filter).

Could this be an option to include in the column total options? I.e. display as subtotal rather than total.

2 Comments

Avatar

Avatar
Give Back 3
Level 1
keithyap
Level 1

Likes

0 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Ignite 1
Give Back
View profile

Avatar
Give Back 3
Level 1
keithyap
Level 1

Likes

0 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Ignite 1
Give Back
View profile
keithyap
Level 1

02-07-2018

While Adobe takes their time to implement this 'idea', you can get around this design flaw by selecting all rows after filtering, right click and 'display only selected rows'. The column subtotal will then calculate correctly.

Avatar

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

362 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

362 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Level 10

27-10-2020

 
Status changed to: Archived